SQL Commands / Version comparison
What changed?
SQL Commands · PostgreSQL 9.1 → 9.2
Historical documentation for a PostgreSQL version that is no longer supported.
0 added · 0 removed · 44 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedCREATE SEQUENCE
--- 9.1
+++ 9.2
@@ -1,4 +1,4 @@
CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
-[ OWNED BY { table.column | NONE } ]
+[ OWNED BY { table_name.column_name | NONE } ]
changedALTER SEQUENCE
--- 9.1
+++ 9.2
@@ -1,9 +1,9 @@
-ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]
+ALTER SEQUENCE [ IF EXISTS ] name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ]
[ RESTART [ [ WITH ] restart ] ]
[ CACHE cache ] [ [ NO ] CYCLE ]
-[ OWNED BY { table.column | NONE } ]
-ALTER SEQUENCE name OWNER TO new_owner
-ALTER SEQUENCE name RENAME TO new_name
-ALTER SEQUENCE name SET SCHEMA new_schema
+[ OWNED BY { table_name.column_name | NONE } ]
+ALTER SEQUENCE [ IF EXISTS ] name OWNER TO new_owner
+ALTER SEQUENCE [ IF EXISTS ] name RENAME TO new_name
+ALTER SEQUENCE [ IF EXISTS ] name SET SCHEMA new_schema
changedCREATE TABLE
--- 9.1
+++ 9.2
@@ -1,13 +1,13 @@
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [
{ column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
| table_constraint
-| LIKE parent_table [ like_option ... ] }
+| LIKE source_table [ like_option ... ] }
[, ... ]
] )
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
-[ TABLESPACE tablespace ]
+[ TABLESPACE tablespace_name ]
CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name
OF type_name [ (
@@ -17,14 +17,14 @@
) ]
[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
-[ TABLESPACE tablespace ]
+[ TABLESPACE tablespace_name ]
where column_constraint is:
[ CONSTRAINT constraint_name ]
{ NOT NULL |
NULL |
-CHECK ( expression ) |
+CHECK ( expression ) [ NO INHERIT ] |
DEFAULT default_expr |
UNIQUE index_parameters |
PRIMARY KEY index_parameters |
@@ -35,7 +35,7 @@
and table_constraint is:
[ CONSTRAINT constraint_name ]
-{ CHECK ( expression ) |
+{ CHECK ( expression ) [ NO INHERIT ] |
UNIQUE ( column_name [, ... ] ) index_parameters |
PRIMARY KEY ( column_name [, ... ] ) index_parameters |
EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) index_parameters [ WHERE ( predicate ) ] |
@@ -50,8 +50,8 @@
index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:
[ WITH ( storage_parameter [= value] [, ... ] ) ]
-[ USING INDEX TABLESPACE tablespace ]
+[ USING INDEX TABLESPACE tablespace_name ]
exclude_element in an EXCLUDE constraint is:
-{ column | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
+{ column_name | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
changedALTER TABLE
--- 9.1
+++ 9.2
@@ -1,23 +1,25 @@
-ALTER TABLE [ ONLY ] name [ * ]
+ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
action [, ... ]
-ALTER TABLE [ ONLY ] name [ * ]
-RENAME [ COLUMN ] column TO new_column
-ALTER TABLE name
+ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
+RENAME [ COLUMN ] column_name TO new_column_name
+ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
+RENAME CONSTRAINT constraint_name TO new_constraint_name
+ALTER TABLE [ IF EXISTS ] name
RENAME TO new_name
-ALTER TABLE name
+ALTER TABLE [ IF EXISTS ] name
SET SCHEMA new_schema
where action is one of:
-ADD [ COLUMN ] column data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
-DROP [ COLUMN ] [ IF EXISTS ] column [ RESTRICT | CASCADE ]
-ALTER [ COLUMN ] column [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]
-ALTER [ COLUMN ] column SET DEFAULT expression
-ALTER [ COLUMN ] column DROP DEFAULT
-ALTER [ COLUMN ] column { SET | DROP } NOT NULL
-ALTER [ COLUMN ] column SET STATISTICS integer
-ALTER [ COLUMN ] column SET ( attribute_option = value [, ... ] )
-ALTER [ COLUMN ] column RESET ( attribute_option [, ... ] )
-ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }
+ADD [ COLUMN ] column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
+DROP [ COLUMN ] [ IF EXISTS ] column_name [ RESTRICT | CASCADE ]
+ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]
+ALTER [ COLUMN ] column_name SET DEFAULT expression
+ALTER [ COLUMN ] column_name DROP DEFAULT
+ALTER [ COLUMN ] column_name { SET | DROP } NOT NULL
+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 }
ADD table_constraint [ NOT VALID ]
ADD table_constraint_using_index
VALIDATE CONSTRAINT constraint_name
changedCREATE TABLE AS
--- 9.1
+++ 9.2
@@ -2,6 +2,6 @@
[ (column_name [, ...] ) ]
[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
-[ TABLESPACE tablespace ]
+[ TABLESPACE tablespace_name ]
AS query
[ WITH [ NO ] DATA ]
changedCREATE VIEW
--- 9.1 +++ 9.2 @@ -1,2 +1,3 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] VIEW name [ ( column_name [, ...] ) ] +[ WITH ( view_option_name [= view_option_value] [, ... ] ) ] AS query
changedALTER VIEW
--- 9.1 +++ 9.2 @@ -1,5 +1,7 @@ -ALTER VIEW name ALTER [ COLUMN ] column SET DEFAULT expression -ALTER VIEW name ALTER [ COLUMN ] column DROP DEFAULT -ALTER VIEW name OWNER TO new_owner -ALTER VIEW name RENAME TO new_name -ALTER VIEW name SET SCHEMA new_schema +ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name SET DEFAULT expression +ALTER VIEW [ IF EXISTS ] name ALTER [ COLUMN ] column_name DROP DEFAULT +ALTER VIEW [ IF EXISTS ] name OWNER TO new_owner +ALTER VIEW [ IF EXISTS ] name RENAME TO new_name +ALTER VIEW [ IF EXISTS ] name SET SCHEMA new_schema +ALTER VIEW [ IF EXISTS ] name SET ( view_option_name [= view_option_value] [, ... ] ) +ALTER VIEW [ IF EXISTS ] name RESET ( view_option_name [, ... ] )
changedCREATE INDEX
--- 9.1
+++ 9.2
@@ -1,5 +1,5 @@
-CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ name ] ON table [ USING method ]
-( { column | ( expression ) } [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
+CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ name ] ON table_name [ USING method ]
+( { column_name | ( expression ) } [ COLLATE collation ] [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ] [, ...] )
[ WITH ( storage_parameter = value [, ... ] ) ]
-[ TABLESPACE tablespace ]
+[ TABLESPACE tablespace_name ]
[ WHERE predicate ]
changedALTER INDEX
--- 9.1 +++ 9.2 @@ -1,4 +1,4 @@ -ALTER INDEX name RENAME TO new_name -ALTER INDEX name SET TABLESPACE tablespace_name -ALTER INDEX name SET ( storage_parameter = value [, ... ] ) -ALTER INDEX name RESET ( storage_parameter [, ... ] ) +ALTER INDEX [ IF EXISTS ] name RENAME TO new_name +ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name +ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter = value [, ... ] ) +ALTER INDEX [ IF EXISTS ] name RESET ( storage_parameter [, ... ] )
changedDROP INDEX
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP INDEX [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] +DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
changedALTER AGGREGATE
--- 9.1 +++ 9.2 @@ -1,3 +1,3 @@ -ALTER AGGREGATE name ( type [ , ... ] ) RENAME TO new_name -ALTER AGGREGATE name ( type [ , ... ] ) OWNER TO new_owner -ALTER AGGREGATE name ( type [ , ... ] ) SET SCHEMA new_schema +ALTER AGGREGATE name ( argtype [ , ... ] ) RENAME TO new_name +ALTER AGGREGATE name ( argtype [ , ... ] ) OWNER TO new_owner +ALTER AGGREGATE name ( argtype [ , ... ] ) SET SCHEMA new_schema
changedDROP AGGREGATE
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP AGGREGATE [ IF EXISTS ] name ( type [ , ... ] ) [ CASCADE | RESTRICT ] +DROP AGGREGATE [ IF EXISTS ] name ( argtype [ , ... ] ) [ CASCADE | RESTRICT ]
changedCREATE FUNCTION
--- 9.1
+++ 9.2
@@ -4,7 +4,7 @@
| RETURNS TABLE ( column_name column_type [, ...] ) ]
{ LANGUAGE lang_name
| WINDOW
-| IMMUTABLE | STABLE | VOLATILE
+| IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
| COST execution_cost
changedALTER FUNCTION
--- 9.1 +++ 9.2 @@ -9,7 +9,7 @@ where action is one of: CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT -IMMUTABLE | STABLE | VOLATILE +IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER COST execution_cost ROWS result_rows
changedALTER DOMAIN
--- 9.1
+++ 9.2
@@ -3,10 +3,16 @@
ALTER DOMAIN name
{ SET | DROP } NOT NULL
ALTER DOMAIN name
-ADD domain_constraint
+ADD domain_constraint [ NOT VALID ]
ALTER DOMAIN name
-DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
+DROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ]
+ALTER DOMAIN name
+RENAME CONSTRAINT constraint_name TO new_constraint_name
+ALTER DOMAIN name
+VALIDATE CONSTRAINT constraint_name
ALTER DOMAIN name
OWNER TO new_owner
ALTER DOMAIN name
+RENAME TO new_name
+ALTER DOMAIN name
SET SCHEMA new_schema
changedCREATE TYPE
--- 9.1 +++ 9.2 @@ -3,6 +3,14 @@ CREATE TYPE name AS ENUM ( [ 'label' [, ... ] ] ) + +CREATE TYPE name AS RANGE ( +SUBTYPE = subtype +[ , SUBTYPE_OPCLASS = subtype_operator_class ] +[ , COLLATION = collation ] +[ , CANONICAL = canonical_function ] +[ , SUBTYPE_DIFF = subtype_diff_function ] +) CREATE TYPE name ( INPUT = input_function,
changedCREATE DATABASE
--- 9.1 +++ 9.2 @@ -4,5 +4,5 @@ [ ENCODING [=] encoding ] [ LC_COLLATE [=] lc_collate ] [ LC_CTYPE [=] lc_ctype ] -[ TABLESPACE [=] tablespace ] +[ TABLESPACE [=] tablespace_name ] [ CONNECTION LIMIT [=] connlimit ] ]
changedDROP TABLESPACE
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP TABLESPACE [ IF EXISTS ] tablespace_name +DROP TABLESPACE [ IF EXISTS ] name
changedGRANT
--- 9.1
+++ 9.2
@@ -4,8 +4,8 @@
| ALL TABLES IN SCHEMA schema_name [, ...] }
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
-GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( column [, ...] )
-[, ...] | ALL [ PRIVILEGES ] ( column [, ...] ) }
+GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( column_name [, ...] )
+[, ...] | ALL [ PRIVILEGES ] ( column_name [, ...] ) }
ON [ TABLE ] table_name [, ...]
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
@@ -17,6 +17,10 @@
GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }
ON DATABASE database_name [, ...]
+TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
+
+GRANT { USAGE | ALL [ PRIVILEGES ] }
+ON DOMAIN domain_name [, ...]
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
GRANT { USAGE | ALL [ PRIVILEGES ] }
@@ -48,4 +52,8 @@
ON TABLESPACE tablespace_name [, ...]
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
+GRANT { USAGE | ALL [ PRIVILEGES ] }
+ON TYPE type_name [, ...]
+TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
+
GRANT role_name [, ...] TO role_name [, ...] [ WITH ADMIN OPTION ]
changedREVOKE
--- 9.1
+++ 9.2
@@ -7,8 +7,8 @@
[ CASCADE | RESTRICT ]
REVOKE [ GRANT OPTION FOR ]
-{ { SELECT | INSERT | UPDATE | REFERENCES } ( column [, ...] )
-[, ...] | ALL [ PRIVILEGES ] ( column [, ...] ) }
+{ { SELECT | INSERT | UPDATE | REFERENCES } ( column_name [, ...] )
+[, ...] | ALL [ PRIVILEGES ] ( column_name [, ...] ) }
ON [ TABLE ] table_name [, ...]
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
@@ -24,6 +24,12 @@
REVOKE [ GRANT OPTION FOR ]
{ { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }
ON DATABASE database_name [, ...]
+FROM { [ GROUP ] role_name | PUBLIC } [, ...]
+[ CASCADE | RESTRICT ]
+
+REVOKE [ GRANT OPTION FOR ]
+{ USAGE | ALL [ PRIVILEGES ] }
+ON DOMAIN domain_name [, ...]
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
@@ -70,6 +76,12 @@
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
+REVOKE [ GRANT OPTION FOR ]
+{ USAGE | ALL [ PRIVILEGES ] }
+ON TYPE type_name [, ...]
+FROM { [ GROUP ] role_name | PUBLIC } [, ...]
+[ CASCADE | RESTRICT ]
+
REVOKE [ ADMIN OPTION FOR ]
role_name [, ...] FROM role_name [, ...]
[ CASCADE | RESTRICT ]
changedALTER DEFAULT PRIVILEGES
--- 9.1
+++ 9.2
@@ -16,6 +16,10 @@
GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTIONS
+TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
+
+GRANT { USAGE | ALL [ PRIVILEGES ] }
+ON TYPES
TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]
REVOKE [ GRANT OPTION FOR ]
@@ -37,3 +41,9 @@
ON FUNCTIONS
FROM { [ GROUP ] role_name | PUBLIC } [, ...]
[ CASCADE | RESTRICT ]
+
+REVOKE [ GRANT OPTION FOR ]
+{ USAGE | ALL [ PRIVILEGES ] }
+ON TYPES
+FROM { [ GROUP ] role_name | PUBLIC } [, ...]
+[ CASCADE | RESTRICT ]
changedSECURITY LABEL
--- 9.1 +++ 9.2 @@ -3,13 +3,16 @@ TABLE object_name | COLUMN table_name.column_name | AGGREGATE agg_name (agg_type [, ...] ) | +DATABASE object_name | DOMAIN object_name | FOREIGN TABLE object_name FUNCTION function_name ( [ [ argmode ] [ argname ] argtype [, ...] ] ) | LARGE OBJECT large_object_oid | [ PROCEDURAL ] LANGUAGE object_name | +ROLE object_name | SCHEMA object_name | SEQUENCE object_name | +TABLESPACE object_name | TYPE object_name | VIEW object_name } IS 'label'
changedALTER USER
--- 9.1
+++ 9.2
@@ -15,7 +15,7 @@
ALTER USER name RENAME TO new_name
-ALTER USER name SET configuration_parameter { TO | = } { value | DEFAULT }
-ALTER USER name SET configuration_parameter FROM CURRENT
-ALTER USER name RESET configuration_parameter
-ALTER USER name RESET ALL
+ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT }
+ALTER USER name [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT
+ALTER USER name [ IN DATABASE database_name ] RESET configuration_parameter
+ALTER USER name [ IN DATABASE database_name ] RESET ALL
changedCREATE RULE
--- 9.1
+++ 9.2
@@ -1,3 +1,3 @@
CREATE [ OR REPLACE ] RULE name AS ON event
-TO table [ WHERE condition ]
+TO table_name [ WHERE condition ]
DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) }
changedDROP RULE
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP RULE [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ] +DROP RULE [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
changedCREATE TRIGGER
--- 9.1
+++ 9.2
@@ -1,5 +1,5 @@
CREATE [ CONSTRAINT ] TRIGGER name { BEFORE | AFTER | INSTEAD OF } { event [ OR ... ] }
-ON table
+ON table_name
[ FROM referenced_table_name ]
[ NOT DEFERRABLE | [ DEFERRABLE ] { INITIALLY IMMEDIATE | INITIALLY DEFERRED } ]
[ FOR [ EACH ] { ROW | STATEMENT } ]
changedALTER TRIGGER
--- 9.1 +++ 9.2 @@ -1 +1 @@ -ALTER TRIGGER name ON table RENAME TO new_name +ALTER TRIGGER name ON table_name RENAME TO new_name
changedDROP TRIGGER
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP TRIGGER [ IF EXISTS ] name ON table [ CASCADE | RESTRICT ] +DROP TRIGGER [ IF EXISTS ] name ON table_name [ CASCADE | RESTRICT ]
changedALTER EXTENSION
--- 9.1 +++ 9.2 @@ -1,7 +1,7 @@ -ALTER EXTENSION extension_name UPDATE [ TO new_version ] -ALTER EXTENSION extension_name SET SCHEMA new_schema -ALTER EXTENSION extension_name ADD member_object -ALTER EXTENSION extension_name DROP member_object +ALTER EXTENSION name UPDATE [ TO new_version ] +ALTER EXTENSION name SET SCHEMA new_schema +ALTER EXTENSION name ADD member_object +ALTER EXTENSION name DROP member_object where member_object is: AGGREGATE agg_name (agg_type [, ...] ) |
changedDROP EXTENSION
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP EXTENSION [ IF EXISTS ] extension_name [, ...] [ CASCADE | RESTRICT ] +DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
changedALTER FOREIGN DATA WRAPPER
--- 9.1 +++ 9.2 @@ -3,3 +3,4 @@ [ VALIDATOR validator_function | NO VALIDATOR ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ]) ] ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner +ALTER FOREIGN DATA WRAPPER name RENAME TO new_name
changedCREATE FOREIGN TABLE
--- 9.1
+++ 9.2
@@ -1,5 +1,5 @@
CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [
-{ column_name data_type [ NULL | NOT NULL ] }
+{ column_name data_type [ OPTIONS ( option 'value' [, ... ] ) ] [ NULL | NOT NULL ] }
[, ... ]
] )
SERVER server_name
changedALTER FOREIGN TABLE
--- 9.1
+++ 9.2
@@ -1,16 +1,20 @@
-ALTER FOREIGN TABLE name
+ALTER FOREIGN TABLE [ IF EXISTS ] name
action [, ... ]
-ALTER FOREIGN TABLE name
-RENAME [ COLUMN ] column TO new_column
-ALTER FOREIGN TABLE name
+ALTER FOREIGN TABLE [ IF EXISTS ] name
+RENAME [ COLUMN ] column_name TO new_column_name
+ALTER FOREIGN TABLE [ IF EXISTS ] name
RENAME TO new_name
-ALTER FOREIGN TABLE name
+ALTER FOREIGN TABLE [ IF EXISTS ] name
SET SCHEMA new_schema
where action is one of:
-ADD [ COLUMN ] column type [ NULL | NOT NULL ]
-DROP [ COLUMN ] [ IF EXISTS ] column [ RESTRICT | CASCADE ]
-ALTER [ COLUMN ] column [ SET DATA ] TYPE type
-ALTER [ COLUMN ] column { SET | DROP } NOT NULL
+ADD [ COLUMN ] column_name data_type [ NULL | NOT NULL ]
+DROP [ COLUMN ] [ IF EXISTS ] column_name [ RESTRICT | CASCADE ]
+ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type
+ALTER [ COLUMN ] column_name { SET | DROP } NOT NULL
+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 OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ])
OWNER TO new_owner
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ])
changedALTER SERVER
--- 9.1 +++ 9.2 @@ -1,3 +1,4 @@ -ALTER SERVER server_name [ VERSION 'new_version' ] +ALTER SERVER name [ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] -ALTER SERVER server_name OWNER TO new_owner +ALTER SERVER name OWNER TO new_owner +ALTER SERVER name RENAME TO new_name
changedDROP SERVER
--- 9.1 +++ 9.2 @@ -1 +1 @@ -DROP SERVER [ IF EXISTS ] server_name [ CASCADE | RESTRICT ] +DROP SERVER [ IF EXISTS ] name [ CASCADE | RESTRICT ]
changedCOPY
--- 9.1
+++ 9.2
@@ -1,8 +1,8 @@
-COPY table_name [ ( column [, ...] ) ]
+COPY table_name [ ( column_name [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ] ( option [, ...] ) ]
-COPY { table_name [ ( column [, ...] ) ] | ( query ) }
+COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }
TO { 'filename' | STDOUT }
[ [ WITH ] ( option [, ...] ) ]
@@ -15,6 +15,6 @@
HEADER [ boolean ]
QUOTE 'quote_character'
ESCAPE 'escape_character'
-FORCE_QUOTE { ( column [, ...] ) | * }
-FORCE_NOT_NULL ( column [, ...] )
+FORCE_QUOTE { ( column_name [, ...] ) | * }
+FORCE_NOT_NULL ( column_name [, ...] )
ENCODING 'encoding_name'
changedDELETE
--- 9.1 +++ 9.2 @@ -1,5 +1,5 @@ [ WITH [ RECURSIVE ] with_query [, ...] ] -DELETE FROM [ ONLY ] table [ * ] [ [ AS ] alias ] +DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ] [ USING using_list ] [ WHERE condition | WHERE CURRENT OF cursor_name ] [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
changedEXPLAIN
--- 9.1
+++ 9.2
@@ -6,4 +6,5 @@
VERBOSE [ boolean ]
COSTS [ boolean ]
BUFFERS [ boolean ]
+TIMING [ boolean ]
FORMAT { TEXT | XML | JSON | YAML }
changedINSERT
--- 9.1
+++ 9.2
@@ -1,4 +1,4 @@
[ WITH [ RECURSIVE ] with_query [, ...] ]
-INSERT INTO table [ ( column [, ...] ) ]
+INSERT INTO table_name [ ( column_name [, ...] ) ]
{ DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
changedSELECT
--- 9.1 +++ 9.2 @@ -23,6 +23,6 @@ from_item [ NATURAL ] join_type from_item [ ON join_condition | USING ( join_column [, ...] ) ] and with_query is: -with_query_name [ ( column_name [, ...] ) ] AS ( select | insert | update | delete ) +with_query_name [ ( column_name [, ...] ) ] AS ( select | values | insert | update | delete ) TABLE [ ONLY ] table_name [ * ]
changedUPDATE
--- 9.1
+++ 9.2
@@ -1,7 +1,7 @@
[ WITH [ RECURSIVE ] with_query [, ...] ]
-UPDATE [ ONLY ] table [ * ] [ [ AS ] alias ]
-SET { column = { expression | DEFAULT } |
-( column [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...]
+UPDATE [ ONLY ] table_name [ * ] [ [ AS ] alias ]
+SET { column_name = { expression | DEFAULT } |
+( column_name [, ...] ) = ( { expression | DEFAULT } [, ...] ) } [, ...]
[ FROM from_list ]
[ WHERE condition | WHERE CURRENT OF cursor_name ]
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
changedSET TRANSACTION
--- 9.1 +++ 9.2 @@ -1,4 +1,5 @@ SET TRANSACTION transaction_mode [, ...] +SET TRANSACTION SNAPSHOT snapshot_id SET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, ...] where transaction_mode is one of:
changedANALYZE
--- 9.1 +++ 9.2 @@ -1 +1 @@ -ANALYZE [ VERBOSE ] [ table [ ( column [, ...] ) ] ] +ANALYZE [ VERBOSE ] [ table_name [ ( column_name [, ...] ) ] ]
changedVACUUM
--- 9.1
+++ 9.2
@@ -1,3 +1,3 @@
-VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table [ (column [, ...] ) ] ]
-VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table ]
-VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table [ (column [, ...] ) ] ]
+VACUUM [ ( { FULL | FREEZE | VERBOSE | ANALYZE } [, ...] ) ] [ table_name [ (column_name [, ...] ) ] ]
+VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] [ table_name ]
+VACUUM [ FULL ] [ FREEZE ] [ VERBOSE ] ANALYZE [ table_name [ (column_name [, ...] ) ] ]