| Name |
Aliases |
Beschreibung |
| bigint |
int8 |
signed eight-byte integer |
| bigserial |
serial8 |
autoincrementing eight-byte integer |
| bit |
|
fixed-length bit string |
| boolean |
bool |
logical Boolean (true/false) |
| bytea |
|
binary data (“byte array”) |
| character |
char [ (n) ] |
fixed-length character string |
| character varying |
varchar [ (n) ] |
variable-length character string |
| date |
|
calendar date (year, month, day) |
| double precision |
float8 |
double precision floating-point number (8 bytes) |
| integer |
int, int4 |
signed four-byte integer |
| money |
|
currency amount |
| numeric |
decimal [ (p, s) ] |
exact numeric of selectable precision |
| real |
float4 |
single precision floating-point number (4 bytes) |
| smallint |
int2 |
signed two-byte integer |
| smallserial |
serial2 |
autoincrementing two-byte integer |
| serial |
serial4 |
autoincrementing four-byte integer |
| text |
|
variable-length character string |
| time |
|
time of day (no time zone) |
| time without time zone |
timetz |
time of day, including time zone |
| timestamp |
|
date and time (no time zone) |
| timestamp with time zone |
timestamptz |
date and time, including time zone |
| uuid |
|
universally unique identifier |
| xml |
|
XML data |
