qKrp4cX9

1CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [
2  { column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
3    | table_constraint
4    | LIKE source_table [ like_option ... ] }
5    [, ... ]
6] )
7[ INHERITS ( parent_table [, ... ] ) ]
8[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
9[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
10[ TABLESPACE tablespace_name ]
11
12CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name
13    OF type_name [ (
14  { column_name WITH OPTIONS [ column_constraint [ ... ] ]
15    | table_constraint }
16    [, ... ]
17) ]
18[ WITH ( storage_parameter [= value] [, ... ] ) | WITH OIDS | WITHOUT OIDS ]
19[ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ]
20[ TABLESPACE tablespace_name ]
21
22where column_constraint is:
23
24[ CONSTRAINT constraint_name ]
25{ NOT NULL |
26  NULL |
27  CHECK ( expression ) [ NO INHERIT ] |
28  DEFAULT default_expr |
29  UNIQUE index_parameters |
30  PRIMARY KEY index_parameters |
31  REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]
32    [ ON DELETE action ] [ ON UPDATE action ] }
33[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
34
35and table_constraint is:
36
37[ CONSTRAINT constraint_name ]
38{ CHECK ( expression ) [ NO INHERIT ] |
39  UNIQUE ( column_name [, ... ] ) index_parameters |
40  PRIMARY KEY ( column_name [, ... ] ) index_parameters |
41  EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) index_parameters [ WHERE ( predicate ) ] |
42  FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
43    [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] }
44[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
45
46and like_option is:
47
48{ INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES | STORAGE | COMMENTS | ALL }
49
50index_parameters in UNIQUE, PRIMARY KEY, and EXCLUDE constraints are:
51
52[ WITH ( storage_parameter [= value] [, ... ] ) ]
53[ USING INDEX TABLESPACE tablespace_name ]
54
55exclude_element in an EXCLUDE constraint is:
56
57{ column_name | ( expression ) } [ opclass ] [ ASC | DESC ] [ NULLS { FIRST | LAST } ]