PG sql相关

修改字段

alter table lark_user ALTER department_id type varchar(46) USING department_id::varchar(46) [];

comment on column lark_user.department_id is '用户所属部门的ID列表';

语法备注

ALTER TABLE [ ONLY ] name [ * ]

action [, ... ]

ALTER TABLE [ ONLY ] name [ * ]

RENAME [ COLUMN ] column TO new_column

ALTER TABLE name

RENAME TO new_name

ALTER TABLE name

SET SCHEMA new_schema

where action is one of:

ADD [ COLUMN ] column data_type [ COLLATE collation ] [ column_constraint [ ... ] ]

DROP [ COLUMN ] [ IF EXISTS ] column [ RESTRICT | CASCADE ]

ALTER [ COLUMN ] column [ SET DATA ] TYPE data_type [ COLLATE collation ] [ USING expression ]

ALTER [ COLUMN ] column SET DEFAULT expression

ALTER [ COLUMN ] column DROP DEFAULT

ALTER [ COLUMN ] column { SET | DROP } NOT NULL

ALTER [ COLUMN ] column SET STATISTICS integer

ALTER [ COLUMN ] column SET ( attribute_option = value [, ... ] )

ALTER [ COLUMN ] column RESET ( attribute_option [, ... ] )

ALTER [ COLUMN ] column SET STORAGE { PLAIN | EXTERNAL | EXTENDED | MAIN }

ADD table_constraint [ NOT VALID ]

ADD table_constraint_using_index

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

CLUSTER ON index_name

SET WITHOUT CLUSTER

SET WITH OIDS

SET WITHOUT OIDS

SET ( storage_parameter = value [, ... ] )

RESET ( storage_parameter [, ... ] )

INHERIT parent_table

NO INHERIT parent_table

OF type_name

NOT OF

OWNER TO new_owner

SET TABLESPACE new_tablespace

and table_constraint_using_index is:

[ CONSTRAINT constraint_name ]

{ UNIQUE | PRIMARY KEY } USING INDEX index_name

[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]