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
824
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES | |||||
BIGINT | NUMERIC | -9223372036854775808 to 9223372036854775807 | X | X | about 18 decimal places |
BIGSERIAL GLOBAL | NUMERIC | X | X | ||
BIGSERIAL LOCAL | NUMERIC | X | X | ||
BIT | PGBIT | X | X | X | fixed-length bit CHARACTER |
BIT VARYING | PGBIT | X | X | X | fixed-length bit CHARACTER |
BOOL | BOOLEAN | X | X | X | logical Boolean (true/false) |
BOOLEAN | BOOLEAN | X | X | X | logical Boolean (true/false) |
DECIMAL | NUMERIC | no limit | 15 | 5 | User-specified precision |
DOUBLE PRECISION | NUMERIC | 1E-307 to 1E+308 | X | X | Variable-precision 15 decimal places |
FLOAT | NUMERIC | X | X | X | |
FLOAT4 | NUMERIC | X | X | X | |
FLOAT8 | NUMERIC | X | X | X | |
INT | NUMERIC | X | X | ||
INT2 | NUMERIC | X | X | -32768 to +32767 | |
INT4 | NUMERIC | X | X | ||
INT8 | NUMERIC | X | X | X | |
INTEGER | NUMERIC | -2147483648 to +2147483647 | X | X | -2147483648 to +2147483647 |
NUMERIC | NUMERIC | no limit | 15 | 5 | User-specified precision |
REAL | NUMERIC | X | X | X | |
SERIAL GLOBAL | NUMERIC | 1 to 2147483647 | X | X | Identifier or cross-reference 0 to +2147483647 - It is typically used to create unique identifiers for table entries. |
SERIAL LOCAL | NUMERIC | 1 to 2147483647 | X | X | Identifier or cross-reference 0 to +2147483647 - It is typically used to create unique identifiers for table entries. |
SMALLINT | NUMERIC | -32768 to +32767 | X | X | -32768 to +32767 |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | X | X | ||
CHARACTER | CHARACTER | X | X | ||
VARCHAR | CHARACTER | X | X | variable-length with limit – 1GB maximum length | |
DATE & TIME DATA TYPES | |||||
DATE | DATE | 4713 BC To 5874897 AD |
X | X | Date Only - 4713 BC 32767 AD |
TIME | TIME | X | X | X | Time of day only - 00:00:00.00 to 23:59:59.99 1 microsecond |
TIMESTAMP | TIMESTAMP | 4713 BC to 5874897 AD |
X | X | Date and Time - 4713 BC to AD 1465001 - 1 microsecond |
TIMESTAMPTZ | X | X | X | TDate and Time - 4713 BC to AD 1465001 - 1 microsecond, including time zone | |
TIMETZ | X | X | X | time of day, including time zone | |
BINARY & LARGE OBJECT DATA TYPES | |||||
TEXT | CHARACTER | X | X | X | Variable unlimited length |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017
real type has a range of at least 1E-37 to 1E+37
real type has a range of at least 1E-37 to 1E+37