@@ -85,6 +85,27 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable>
8585 OWNER TO { <replaceable class="parameter">new_owner</replaceable> | CURRENT_USER | SESSION_USER }
8686 REPLICA IDENTITY { DEFAULT | USING INDEX <replaceable class="parameter">index_name</replaceable> | FULL | NOTHING }
8787
88+ <phrase>and <replaceable class="parameter">partition_bound_spec</replaceable> is:</phrase>
89+
90+ IN ( { <replaceable class="parameter">numeric_literal</replaceable> | <replaceable class="parameter">string_literal</replaceable> | NULL } [, ...] ) |
91+ FROM ( { <replaceable class="parameter">numeric_literal</replaceable> | <replaceable class="parameter">string_literal</replaceable> | MINVALUE | MAXVALUE } [, ...] )
92+ TO ( { <replaceable class="parameter">numeric_literal</replaceable> | <replaceable class="parameter">string_literal</replaceable> | MINVALUE | MAXVALUE } [, ...] ) |
93+ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REMAINDER <replaceable class="parameter">numeric_literal</replaceable> )
94+
95+ <phrase>and <replaceable class="parameter">column_constraint</replaceable> is:</phrase>
96+
97+ [ CONSTRAINT <replaceable class="parameter">constraint_name</replaceable> ]
98+ { NOT NULL |
99+ NULL |
100+ CHECK ( <replaceable class="parameter">expression</replaceable> ) [ NO INHERIT ] |
101+ DEFAULT <replaceable>default_expr</replaceable> |
102+ GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY [ ( <replaceable>sequence_options</replaceable> ) ] |
103+ UNIQUE <replaceable class="parameter">index_parameters</replaceable> |
104+ PRIMARY KEY <replaceable class="parameter">index_parameters</replaceable> |
105+ REFERENCES <replaceable class="parameter">reftable</replaceable> [ ( <replaceable class="parameter">refcolumn</replaceable> ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]
106+ [ ON DELETE <replaceable class="parameter">action</replaceable> ] [ ON UPDATE <replaceable class="parameter">action</replaceable> ] }
107+ [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
108+
88109<phrase>and <replaceable class="parameter">table_constraint</replaceable> is:</phrase>
89110
90111[ CONSTRAINT <replaceable class="parameter">constraint_name</replaceable> ]
@@ -101,6 +122,16 @@ ALTER TABLE [ IF EXISTS ] <replaceable class="parameter">name</replaceable>
101122 [ CONSTRAINT <replaceable class="parameter">constraint_name</replaceable> ]
102123 { UNIQUE | PRIMARY KEY } USING INDEX <replaceable class="parameter">index_name</replaceable>
103124 [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
125+
126+ <phrase><replaceable class="parameter">index_parameters</replaceable> in <literal>UNIQUE</literal>, <literal>PRIMARY KEY</literal>, and <literal>EXCLUDE</literal> constraints are:</phrase>
127+
128+ [ WITH ( <replaceable class="parameter">storage_parameter</replaceable> [= <replaceable class="parameter">value</replaceable>] [, ... ] ) ]
129+ [ USING INDEX TABLESPACE <replaceable class="parameter">tablespace_name</replaceable> ]
130+
131+ <phrase><replaceable class="parameter">exclude_element</replaceable> in an <literal>EXCLUDE</literal> constraint is:</phrase>
132+
133+ { <replaceable class="parameter">column_name</replaceable> | ( <replaceable class="parameter">expression</replaceable> ) } [ <replaceable class="parameter">opclass</replaceable> ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]
134+
104135</synopsis>
105136 </refsynopsisdiv>
106137