Creating tables
Column types (slightly Postgres-specific)
An incomplete list, (continued).
String:
- char(n): String of exactly n characters.
- varchar(n): Varying-length string of up to n characters.
- varchar: Varying-length string, (postgres-specific).
Byte string:
- bytea: Variable-length string of bytes.
Temporal:
- timestamp [with time zone | without time
zone]: date and time, with or without time zone.
- date: date only.
- time [with time zone | without time zone]: time only.
- interval: interval of timestamps.
Others:
- boolean
- UUID
- inet: IP address
|