Beyond standard SQL types, PostgreSQL offers a rich set of specialized data types — JSONB, arrays, UUID, ranges, SERIAL, and more — that make it especially capable for modern applications storing structured, semi-structured, or specialized data.
Standard types (with Postgres notes)
, ,
(p,s)
,
(n), TEXT, (n)
, , , TIMESTAMPTZ
