PostgreSQL's main types cover numbers, text, and dates and times. It also stores binary data and JSON. Arrays, UUIDs and network addresses have their own types too.
- Whole numbers use
integerorbigint. Exact decimals usenumeric, also spelleddecimal, and approximate values userealordouble precision. - Text uses
char,varcharortext. Unlike in some other database systems,charhas no speed advantage in PostgreSQL. - Dates and times use
date,timeandtimestamp, and spans of time useinterval. booleanholdstrueorfalse, andbyteaholds binary data.jsonkeeps JSON as plain text, whilejsonbstores it in a binary form that is faster to query.- Arrays can hold any data type,
uuidstores universally unique identifiers, andinetandcidrstore IP addresses.
Rewriting in plainer words…
This answer doesn't lend itself to a diagram - it reads best . No credits were charged.
Why there's no diagram: “”
The interactive diagram is below the answer - jump to diagram ↓ · Below it, the related concept . Jump to it ↓
The diagram below the answer is the concept . Jump to it ↓
Tailored explanation · switch back to · ·
What should the new diagram focus on?