BYTEA
|
Variable-length binary string |
CHAR
|
Fixed length character string. In Size type the size limit of the character string. |
DATE
|
A calendar date consisting of year/month/day |
DOUBLE PRECISION
|
Double-precision Floating-point number. There are no additional options. |
INTEGER
|
32-bit binary integer. There are no additional options. |
INTERVAL
|
There are no additional options. |
IP4
|
IP address |
IP4Range
|
Range of IP addresses |
NUMERIC
|
Numeric data such as integers, real numbers, and floating-point numbers. An Aster Database numeric must have a scale and precision to be exported, due to the different meanings of precision and scale in different systems. In Precision, type the total count of significant digits in the whole number, that is, the number of digits to both sides of the decimal point. In Scale, type the count of decimal digits in the fractional part, to the right of the decimal point. For example, the number 23.5141 has a precision of 6 and a scale of 4. |
SMALLINT
|
Signed two-byte integer. There are no additional options to enter. |
TEXT
|
Stores strings of any length. In Size type the limit of the text size. |
TIME
|
A time consisting of hour/minute/second/fractional second |
TIME WITH TIME ZONE
|
A TIME with a displacement from UTC |
TIMESTAMP
|
A timestamp consisting of year/month/day/hour/minute/second/fractional second |
TIMESTAMP WITH TIME ZONE
|
A TIMESTAMP with a displacement from UTC |
UUID
|
Stores Universally Unique Identifiers (UUID) as defined by RFC 4122, ISO/IEC 9834-8:2005, and related standards. |
VARBIT
|
Variable length binary string |
VARCHAR
|
Variable length character string |