PostgreSQL Data Types — Compare and Choose the Right Type

Use text unless you need length validation

Use integer for most things, numeric for money

Always use timestamptz, never bare timestamp

Use jsonb — faster and indexable

Just use boolean

Use uuid with gen_random_uuid()

Use bytea; consider external storage for large files

Use for small fixed lists; prefer junction tables otherwise

Prefer GENERATED ALWAYS AS IDENTITY over serial