All available data types are described [here](https://www.postgresql.org/docs/current/datatype.html#DATATYPE-TABLE). | Name | Description | | ------------------ | ----------------------------------------------------------------------------------------- | | `integer` | typical choice for integer | | `real` | inexact floating point up to 6 decimal places (see also `double precision` and `numeric`) | | `text` | variable length character string (see also `varchar(n)`) | | `boolean` | true/false | | `date` | date | | `timestamp` | date and time (see options for time zones) | | `bigserial` | auto-incrementing integer up to 9,223,372,036,854,775,807 | | `uuid` | universally unique identifier | | `money` | currency amount | | `point` | geometric point | | `polygon` | geometric polygon | | `jsonb` | textual json data (see also `json`) | | `varchar(n)` | string not to exceed length n | | `serial` | auto-incrementing integer up to 2,147,483,647 | | `double precision` | inexact floating point up to 15 decimal places | | `numeric` | high precision floats (slow calculations) | | `time` | time only | | `time interval` | interval of time |