SQL PostgreSQL Specific

PostgreSQL-specific features — SERIAL, RETURNING, ARRAY, JSONB, UPSERT. This category documents 57 SQL postgresql specific entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: SERIAL, RETURNING, ARRAY, JSONB, UPSERT (INSERT ON CONFLICT), ILIKE, BIGSERIAL / SMALLSERIAL, GENERATED AS IDENTITY, COPY, EXPLAIN ANALYZE, VACUUM, PARTITION BY (Table Partitioning), LISTEN / NOTIFY, HSTORE, MACADDR / INET / CIDR, ROW Type / Composite Types, TEXT SEARCH (tsvector/tsquery), DISTINCT ON, FOR UPDATE SKIP LOCKED, WINDOW Clause (Named Window), DOMAIN (PostgreSQL), FOREIGN DATA WRAPPER (FDW), PUBLICATION / SUBSCRIPTION, CITEXT, PG_TEMP_DIR / temp_tablespaces, ANALYZE /VACUUM ANALYZE, PGP_SYM_ENCRYPT / PGP_PUB_ENCRYPT, pg_catalog Queries, GENERATE_SERIES(), UUID Generation Methods, WITH ORDINALITY, PG_STAT_STATEMENTS, PL/pgSQL Functions, PostgreSQL EXTENSION Management, PostgreSQL SET Operations, PostgreSQL BRIN Index, PostgreSQL Custom Aggregates, PostgreSQL Event Triggers, PostgreSQL TG_TABLE_NAME (Trigger Context), PostgreSQL Advisory Lock, and more. Not sure where to start? SERIAL and RETURNING are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.