SERIAL and identity columns RETURNING ILIKE DISTINCT ON LIMIT OFFSET VALUES table constructor Type casts :: Dollar-quoted strings Search path Temporary tables

UUID JSONB Arrays Range types INET and CIDR NUMERIC precision TIMESTAMPTZ INTERVAL ENUM type Composite type

LATERAL join FULL OUTER JOIN CROSS JOIN LATERAL FILTER aggregate GROUPING SETS ROLLUP CUBE Window functions Recursive CTE Materialized CTE control

jsonb_extract_path JSONB containment @> jsonb_set jsonb_array_elements jsonb_each Array constructor ANY with arrays Array containment @> unnest() array_agg()

B-tree index Hash index GIN index GiST index BRIN index Partial index Expression index Covering INCLUDE index Concurrent index creation Index-only scan concept

Transaction isolation SAVEPOINT SELECT FOR UPDATE SELECT FOR SHARE Advisory locks Deadlock example Serializable retry Deferrable constraints Two-phase commit SKIP LOCKED

SQL function PL/pgSQL function DO block Trigger function Generated columns LISTEN and NOTIFY COPY command Upsert ON CONFLICT MERGE statement Extensions CREATE EXTENSION

EXPLAIN EXPLAIN ANALYZE VACUUM ANALYZE Autovacuum settings pg_stat_activity Statement timeout Connection roles Row-level security Partitioned tables