Postgres support (alter/drop table)

[nene]

• ALTER TABLE
  • IF EXISTS
  • [ONLY] name [*]
  • ALTER TABLE ALL IN TABLESPACE name [ OWNED BY role_name [, ... ] ]
  • actions:
    • RENAME [ COLUMN ] column_name TO new_column_name
    • RENAME CONSTRAINT constraint_name TO new_constraint_name
    • RENAME TO new_name
    • SET SCHEMA new_schema
    • SET TABLESPACE new_tablespace [ NOWAIT ]
    • ADD [ COLUMN ] [ IF NOT EXISTS ] 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
        • [ SET DATA ] TYPE
        • [ COLLATE collation ]
        • [ USING expression ]
      • SET DEFAULT expression
      • DROP DEFAULT
      • SET NOT NULL
      • DROP NOT NULL
      • modifying generated columns:
        • DROP EXPRESSION [ IF EXISTS ]
        • DROP IDENTITY [ IF EXISTS ]
        • ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
        • ADD GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY ( sequence_options )
        • multiple alter identity actions:
          • SET GENERATED { ALWAYS | BY DEFAULT }
          • SET sequence_option
          • RESTART [ [ WITH ] restart ]
      • SET STATISTICS integer
      • SET ( attribute_option = value [, ... ] )
      • RESET ( attribute_option [, ... ] )
      • SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN | DEFAULT }
      • SET COMPRESSION compression_method
    • ADD table_constraint
      • [ NOT VALID ]
    • ADD table_constraint_using_index:
      • UNIQUE USING INDEX index_name
      • PRIMARY KEY USING INDEX index_name
    • ALTER CONSTRAINT constraint_name [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
    • VALIDATE CONSTRAINT constraint_name
    • DROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ]
    • DISABLE TRIGGER [ trigger_name | ALL | USER ]
    • ENABLE TRIGGER [ trigger_name | ALL | USER ]
    • ENABLE REPLICA TRIGGER trigger_name
    • ENABLE ALWAYS TRIGGER trigger_name
    • DISABLE RULE rewrite_rule_name
    • ENABLE RULE rewrite_rule_name
    • ENABLE REPLICA RULE rewrite_rule_name
    • ENABLE ALWAYS RULE rewrite_rule_name
    • DISABLE ROW LEVEL SECURITY
    • ENABLE ROW LEVEL SECURITY
    • FORCE ROW LEVEL SECURITY
    • NO FORCE ROW LEVEL SECURITY
    • CLUSTER ON index_name
    • SET WITHOUT CLUSTER
    • SET WITHOUT OIDS
    • SET ACCESS METHOD new_access_method
    • SET TABLESPACE new_tablespace
    • SET { LOGGED | UNLOGGED }
    • SET ( storage_parameter [= value] [, ... ] )
    • RESET ( storage_parameter [, ... ] )
    • INHERIT parent_table
    • NO INHERIT parent_table
    • OF type_name
    • NOT OF
    • OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER }
    • REPLICA IDENTITY { DEFAULT | USING INDEX index_name | FULL | NOTHING }
• DROP TABLE
  • IF EXISTS
  • CASCADE | RESTRICT
  • multiple tables