Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
829
|
| Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
| NUMERIC DATA TYPES | |||||
| BIGINT | NUMERIC | X | X | X | BIGINT or INT8 , Signed eight-byte integer, ALIASES =INT8, -9223372036854775807 to 9223372036854775807 |
| INT8 | NUMERIC | X | X | X | Signed eight-byte integer |
| SMALLINT | NUMERIC | X | X | X | SMALLINT or INT2 , Signed two-byte integer, ALIASES =INT2, -32768 to +32767 |
| INT2 | NUMERIC | X | X | X | Signed two-byte integer |
| INTEGER | NUMERIC | X | 10 | 0 | INTEGER, INT, or INT4 , Signed FOUR-byte integer, ALIASES =INT, INT4, -2147483648 to +2147483647 |
| INT | NUMERIC | X | X | X | Signed four-byte integer |
| INT4 | NUMERIC | X | X | X | Signed four-byte integer |
| DECIMAL | NUMERIC | X | X | X | The DECIMAL and NUMERIC keywords are interchangeable. Storage= Variable, up to 8 bytes (always 8 bytes for uncompressed DECIMAL TYPES) ; 8-byte signed integers with up to 19 digits of precision.; Exact numeric of selectable precision. The default precision, if not specified, is 18. The maximum positive value that you can insert into a DECIMAL(19,0) column is 9223372036854775807 (2^63-1) |
| NUMERIC | NUMERIC | X | X | X | The DECIMAL and NUMERIC keywords are interchangeable. Storage= Variable, up to 8 bytes (always 8 bytes for uncompressed DECIMAL TYPES) ; 8-byte signed integers with up to 19 digits of precision.; Exact numeric of selectable precision. The default precision, if not specified, is 18 |
| REAL | NUMERIC | X | X | X | ALIASES =FLOAT4 ; Storage is 4 bytes and Range is 6 significant digits of precision |
| FLOAT4 | NUMERIC | X | X | X | Single precision floating-point number |
| DOUBLE PRECISION | NUMERIC | X | X | X | ALIASES =FLOAT8 ; Storage is 8 bytes and Range is 15 significant digits of precision |
| FLOAT8 | NUMERIC | X | X | X | Double precision floating-point number |
| BOOLEAN | NUMERIC | X | 11 | X | BOOL |
| CHARACTER DATA TYPES | |||||
| CHAR | CHARACTER | 25 | X | X | ALIASES =CHARACTER; A fixed-length string that is always right-padded with spaces to the specified length when stored. Range (width of column) = 65535 bytes (64K -1) |
| CHARACTER | CHARACTER | 25 | X | X | |
| VARCHAR | CHARACTER | 25 | X | X | ALIASES =CHARACTER VARYING; Variable-length character string with a user-defined limit |
| DATE & TIME DATA TYPES | |||||
| DATE | DATE | X | X | X | Calendar date (year, month, day), Range = 4713 BC to 5874897 AD , Resolution 1 day, Storage is 4 bytes |
| TIMESTAMP | TIMESTAMP | X | X | X | Date and time (without time zone), Range = 4713 BC to 5874897 AD , Resolution 1 microsecond, Storage is 8 bytes |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017