Interview Q&A / PostgreSQL
PostgreSQL interview questions
Indexes, EXPLAIN, transactions and isolation, JSONB and the Postgres specifics backend interviews probe.
Prefer rapid revision? Practise PostgreSQL short interview answers →
- Why should you use timestamptz instead of timestamp in PostgreSQL?
timestamptz stores an absolute moment in time (converted to UTC internally) and shows it in the session time zone. timestamp stores a bare date and clock reading with no zone, so the same value means different moments for different users.
BeginnerQuick answer1 min read