| character varying [(n)] | varchar [(n)], text [(n)] | variable-length character string of n bytes: 1..65535, def. 255 |
| binary varying [(n)] | varbinary [(n)], bytes [(n)] | variable-length binary data of n bytes: is 1..65535, def. 255 |
| bigint | int64 | signed eight-byte integer |
| integer | int, int32 | signed four-byte integer |
| smallint | int16 | signed two-byte integer |
| tinyint | int8 | signed one-byte integer |
| real | float, float32 | single precision floating-point number (4 bytes) |
| double precision | float64 | double precision floating-point number (8 bytes) |
| timestamp | | date and time (no time zone) |
| boolean | bool | logical Boolean (true/false) |
| binary large object | blob | binary data |