↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SQL COMMANDS / VERSION COMPARISON

What changed?

SQL Commands · PostgreSQL 15 → 16

Browse PG 16 →

0 added · 0 removed · 15 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

changedALTER MATERIALIZED VIEW
--- 15
+++ 16
@@ -16,7 +16,7 @@
 ALTER [ COLUMN ] column_name SET STATISTICS integer
 ALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )
 ALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )
-ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
+ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
 ALTER [ COLUMN ] column_name SET COMPRESSION compression_method
 CLUSTER ON index_name
 SET WITHOUT CLUSTER
changedCREATE TABLE
--- 15
+++ 16
@@ -1,5 +1,5 @@
 CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [
-{ column_name data_type [ COMPRESSION compression_method ] [ COLLATE collation ] [ column_constraint [ ... ] ]
+{ column_name data_type [ STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT } ] [ COMPRESSION compression_method ] [ COLLATE collation ] [ column_constraint [ ... ] ]
 | table_constraint
 | LIKE source_table [ like_option ... ] }
 [, ... ]
changedALTER TABLE
--- 15
+++ 16
@@ -30,7 +30,7 @@
 ALTER [ COLUMN ] column_name SET STATISTICS integer
 ALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )
 ALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )
-ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
+ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
 ALTER [ COLUMN ] column_name SET COMPRESSION compression_method
 ADD table_constraint [ NOT VALID ]
 ADD table_constraint_using_index
changedREINDEX
--- 15
+++ 16
@@ -1,4 +1,6 @@
-REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } [ CONCURRENTLY ] name
+REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA } [ CONCURRENTLY ] name
+REINDEX [ ( option [, ...] ) ] { DATABASE | SYSTEM } [ CONCURRENTLY ] [ name ]
+
 where option can be one of:
 
 CONCURRENTLY [ boolean ]
changedCREATE STATISTICS
--- 15
+++ 16
@@ -1,8 +1,8 @@
-CREATE STATISTICS [ IF NOT EXISTS ] statistics_name
+CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ]
 ON ( expression )
 FROM table_name
 
-CREATE STATISTICS [ IF NOT EXISTS ] statistics_name
+CREATE STATISTICS [ [ IF NOT EXISTS ] statistics_name ]
 [ ( statistics_kind [, ... ] ) ]
 ON { column_name | ( expression ) }, { column_name | ( expression ) } [, ...]
 FROM table_name
changedCREATE COLLATION
--- 15
+++ 16
@@ -4,6 +4,7 @@
 [ LC_CTYPE = lc_ctype, ]
 [ PROVIDER = provider, ]
 [ DETERMINISTIC = boolean, ]
+[ RULES = rules, ]
 [ VERSION = version ]
 )
 CREATE COLLATION [ IF NOT EXISTS ] name FROM existing_collation
changedCREATE DATABASE
--- 15
+++ 16
@@ -7,6 +7,7 @@
 [ LC_COLLATE [=] lc_collate ]
 [ LC_CTYPE [=] lc_ctype ]
 [ ICU_LOCALE [=] icu_locale ]
+[ ICU_RULES [=] icu_rules ]
 [ LOCALE_PROVIDER [=] locale_provider ]
 [ COLLATION_VERSION = collation_version ]
 [ TABLESPACE [=] tablespace_name ]
changedGRANT
--- 15
+++ 16
@@ -75,7 +75,7 @@
 [ GRANTED BY role_specification ]
 
 GRANT role_name [, ...] TO role_specification [, ...]
-[ WITH ADMIN OPTION ]
+[ WITH { ADMIN | INHERIT | SET } { OPTION | TRUE | FALSE } ]
 [ GRANTED BY role_specification ]
 
 where role_specification can be:
changedREVOKE
--- 15
+++ 16
@@ -102,7 +102,7 @@
 [ GRANTED BY role_specification ]
 [ CASCADE | RESTRICT ]
 
-REVOKE [ ADMIN OPTION FOR ]
+REVOKE [ { ADMIN | INHERIT | SET } OPTION FOR ]
 role_name [, ...] FROM role_specification [, ...]
 [ GRANTED BY role_specification ]
 [ CASCADE | RESTRICT ]
changedALTER FOREIGN TABLE
--- 15
+++ 16
@@ -17,7 +17,7 @@
 ALTER [ COLUMN ] column_name SET STATISTICS integer
 ALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )
 ALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )
-ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
+ALTER [ COLUMN ] column_name SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
 ALTER [ COLUMN ] column_name OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ])
 ADD table_constraint [ NOT VALID ]
 VALIDATE CONSTRAINT constraint_name
changedCOPY
--- 15
+++ 16
@@ -13,6 +13,7 @@
 FREEZE [ boolean ]
 DELIMITER 'delimiter_character'
 NULL 'null_string'
+DEFAULT 'default_string'
 HEADER [ boolean | MATCH ]
 QUOTE 'quote_character'
 ESCAPE 'escape_character'
changedEXPLAIN
--- 15
+++ 16
@@ -6,6 +6,7 @@
 VERBOSE [ boolean ]
 COSTS [ boolean ]
 SETTINGS [ boolean ]
+GENERIC_PLAN [ boolean ]
 BUFFERS [ boolean ]
 WAL [ boolean ]
 TIMING [ boolean ]
changedSELECT
--- 15
+++ 16
@@ -17,7 +17,7 @@
 
 [ ONLY ] table_name [ * ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
 [ TABLESAMPLE sampling_method ( argument [, ...] ) [ REPEATABLE ( seed ) ] ]
-[ LATERAL ] ( select ) [ AS ] alias [ ( column_alias [, ...] ) ]
+[ LATERAL ] ( select ) [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
 with_query_name [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
 [ LATERAL ] function_name ( [ argument [, ...] ] )
 [ WITH ORDINALITY ] [ [ AS ] alias [ ( column_alias [, ...] ) ] ]
changedANALYZE
--- 15
+++ 16
@@ -5,6 +5,6 @@
 
 VERBOSE [ boolean ]
 SKIP_LOCKED [ boolean ]
-
+BUFFER_USAGE_LIMIT size
 and table_and_columns is:
 table_name [ ( column_name [, ...] ) ]
changedVACUUM
--- 15
+++ 16
@@ -10,8 +10,12 @@
 DISABLE_PAGE_SKIPPING [ boolean ]
 SKIP_LOCKED [ boolean ]
 INDEX_CLEANUP { AUTO | ON | OFF }
+PROCESS_MAIN [ boolean ]
 PROCESS_TOAST [ boolean ]
 TRUNCATE [ boolean ]
 PARALLEL integer
+SKIP_DATABASE_STATS [ boolean ]
+ONLY_DATABASE_STATS [ boolean ]
+BUFFER_USAGE_LIMIT size
 and table_and_columns is:
 table_name [ ( column_name [, ...] ) ]