Postgres support (create table)

[nene]

DDL

• [x] CREATE TABLE
  • [x] [GLOBAL | LOCAL] {TEMPORARY | TEMP}
  • [x] UNLOGGED
  • [x] IF NOT EXISTS
  • [x] OF type_name
  • [x] PARTITION OF parent_table
  • [x] column definitions:
    • [x] STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
    • [x] COMPRESSION { pglz | lz4 | default}
    • [x] COLLATE collation
    • [x] column_name [WITH OPTIONS] (syntax sugar which has no effect)
  • [x] column constraints:
    • [x] CONSTRAINT name
    • [x] NULL | NOT NULL
    • [x] CHECK ( expression )
    • [x] DEFAULT expr (unlike SQLite and BigQuery which only support literals in here)
    • [x] GENERATED ALWAYS AS ( expr ) STORED
    • [x] GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
    • [x] GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY ( sequence_options ) see CREATE SEQUENCE
    • [x] UNIQUE [ NULLS [ NOT ] DISTINCT ] index_parameters
    • [x] PRIMARY KEY index_parameters
    • [x] REFERENCES ...
    • [x] NO INHERIT
    • [x] DEFERRABLE | NOT DEFERRABLE
    • [x] INITIALLY DEFERRED | INITIALLY IMMEDIATE
  • [x] table constraints:
    • [x] CONSTRAINT name
    • [x] CHECK ( expression )
    • [x] UNIQUE [ NULLS [ NOT ] DISTINCT ] ( column_name [, ... ] ) index_parameters
    • [x] PRIMARY KEY ( column_name [, ... ] ) index_parameters
    • [x] EXCLUDE
      • [x] [ USING index_method ]
      • [x] ( expr WITH operator [, ... ] )
      • [x] ( expr [opclass] [ASC|DESC] [NULLS {FIRST|LAST}] WITH operator, ... )
      • [x] index_parameters
      • [x] [ WHERE ( predicate ) ]
    • [x] FOREIGN KEY ...
    • [x] NO INHERIT
    • [x] DEFERRABLE | NOT DEFERRABLE
    • [x] INITIALLY DEFERRED | INITIALLY IMMEDIATE
  • [x] references definition:
    • [x] REFERENCES tbl_name [(key_part,...)]
    • [x] ... [MATCH FULL | MATCH PARTIAL | MATCH SIMPLE]
    • [x] ... [ON DELETE referencial_action]
    • [x] ... [ON UPDATE referencial_action]
    • [x] referential_action:
      • [x] RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT
      • [x] SET NULL ( col1, col2, ...)
      • [x] SET DEFAULT ( col1, col2, ...)
  • [x] index_parameters:
    • [x] INCLUDE ( column_name [, ... ] )
    • [x] WITH ( storage_parameter [= value] [, ... ] )
    • [x] USING INDEX TABLESPACE tablespace_name
  • [x] CREATE TABLE .. ( LIKE source_table [like_option] ) unlike with other dialects, the LIKE clause is inside columns list.
    • [x] like options: { INCLUDING | EXCLUDING } { COMMENTS | COMPRESSION | CONSTRAINTS | DEFAULTS | GENERATED | IDENTITY | INDEXES | STATISTICS | STORAGE | ALL }
  • [x] INHERITS (table , ...)
  • [x] FOR VALUES partition_bound_spec | DEFAULT
    • [x] IN ( expr [, ...] )
    • [x] FROM ( { expr | MINVALUE | MAXVALUE } [, ...] ) TO ( { expr | MINVALUE | MAXVALUE } [, ...] )
    • [x] WITH ( MODULUS numeric_literal, REMAINDER numeric_literal )
  • [x] PARTITION BY { RANGE | LIST | HASH } ( part_param, ... ) with part_param consisting of:
    • [x] column_name | ( expr )
    • [x] [COLLATE collation]
    • [x] [opclass]
  • [x] USING method
  • [x] WITH ( storage_parameter [= value] [, ... ] )
  • [x] WITHOUT OIDS
  • [x] ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP }
  • [x] TABLESPACE tablespace_name
  • [x] CREATE TABLE AS
    • [x] (column_name, ...)
    • [x] AS query
    • [x] WITH [NO] DATA
  • [x] CREATE FOREIGN TABLE
    • [x] OPTIONS ( option 'value', ... )
      • [x] as column constraint
      • [x] as create table clause
    • [x] SERVER server_name