Data Types and Columns
Data types restrict the kind of data that can be stored for each column.
PostgreSQL natively supports a rich set of data types. Users can also extend it by adding customised types using
CREATE TYPE command.
We will now look at the list of native types that are supported:
Floating point types
- double precision
- character varying(n) / varchar(n)
- boolean with state of true/false
Date Time Types
Universally Unique Identifiers are 128-bit numbers used to uniquely identify a piece of information and typically in database context it is used to identify a row.
- jsonb (binary form for faster execution)
There are more such supported types including monetary for money related, binary types for raw byte storage, network address types for IP address references, arrays etc. You can read more about all available PostgreSQL Data Types from their official docs.