postgres-sql

The PostgreSQL SQL dialect and data types that set Postgres apart from generic SQL. Use when writing or debugging Postgres-specific SQL — upsert (INSERT ... ON CONFLICT DO UPDATE/NOTHING), RETURNING (incl. OLD/NEW), MERGE, CTEs (WITH/MATERIALIZED/recursive/data-modifying), window frames, GROUPING SETS/CUBE/ROLLUP, DISTINCT ON, LATERAL, FILTER, generated & identity columns, declarative partitioning, jsonb operators + jsonpath + SQL/JSON (JSON_TABLE/IS JSON), arrays, ranges & multiranges, composite/enum/domain types, and functions like uuidv7()/gen_random_uuid()/ANY_VALUE(). Triggers on ON CONFLICT, MERGE, jsonb, @>/->>, GENERATED ... AS IDENTITY, PARTITION BY. Disambiguation — this is the SQL dialect & types; for the psql client use psql, for tuning/EXPLAIN/indexes use postgres-performance, for config/auth/backup use postgres-admin, for contrib use postgres-extensions. Features carry inline (pgNN+) tags; unlisted = long-standing (bedrock since 9.x).