| bigint |
int8 |
signed eight-byte integer |
| bigserial |
serial8 |
autoincrementing eight-byte integer |
| bit [ (n) ] |
|
fixed-length bit string |
| bit varying [ (n) ] |
varbit |
variable-length bit string |
| boolean |
bool |
logical Boolean (true/false) |
| box |
|
rectangular box on a plane |
| bytea |
|
binary data ("byte array") |
| character varying [ (n) ] |
varchar [ (n) ] |
variable-length character string |
| character [ (n) ] |
char [ (n) ] |
fixed-length character string |
| cidr |
|
IPv4 or IPv6 network address |
| circle |
|
circle on a plane |
| date |
|
calendar date (year, month, day) |
| double precision |
float8 |
double precision floating-point number (8 bytes) |
| inet |
|
IPv4 or IPv6 host address |
| integer |
int, int4 |
signed four-byte integer |
| interval [ fields ] [ (p) ] |
|
time span |
| line |
|
infinite line on a plane |
| lseg |
|
line segment on a plane |
| macaddr |
|
MAC (Media Access Control) address |
| money |
|
currency amount |
| numeric [ (p, s) ] |
decimal [ (p, s) ] |
exact numeric of selectable precision |
| path |
|
geometric path on a plane |
| point |
|
geometric point on a plane |
| polygon |
|
closed geometric path on a plane |
| real |
float4 |
single precision floating-point number (4 bytes) |
| smallint |
int2 |
signed two-byte integer |
| serial |
serial4 |
autoincrementing four-byte integer |
| text |
|
variable-length character string |
| time [ (p) ] [ without time zone ] |
|
time of day (no time zone) |
| time [ (p) ] with time zone |
timetz |
time of day, including time zone |
| timestamp [ (p) ] [ without time zone ] |
|
date and time (no time zone) |
| timestamp [ (p) ] with time zone |
timestamptz |
date and time, including time zone |
| tsquery |
|
text search query |
| tsvector |
|
text search document |
| txid_snapshot |
|
user-level transaction ID snapshot |
| uuid |
|
universally unique identifier |
| xml |
|
XML data |
