Postgres support (alter/drop table) #57
Description
- 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
-