數(shù)據(jù)庫操作

ALTER DATABASE name ALLOW_CONNECTIONS true|false; ALTER DATABASE name CONNECTION LIMIT connlimit; ALTER DATABASE name CONNECTION IS_TEMPLATE true|false; ALTER DATABASE name RENAME TO new_name; ALTER DATABASE name OWNER TO new_owner; ALTER DATABASE name SET TABLESPACE new_tablespace; ALTER DATABASE name SET configuration_parameter {TO|=} {value|DEFAULT}; ALTER DATABASE name SET configuration_parameter FROM CURRENT; ALTER DATABASE name RESET configuration_parameter; ALTER DATABASE name RESET ALL;

用戶角色操作

ALTER ROLE|USER role_name WITH PASSWORD 'password'; ALTER ROLE|USER role_name WITH PASSWORD NULL; ALTER ROLE|USER role_name VALID UNTIL 'May 4 12:00:00 2015 +1'; ALTER ROLE|USER role_name VALID UNTIL 'infinity'; ALTER ROLE|USER role_name CREATEROLE CREATEDB; ALTER ROLE|USER role_name SET maintenance_work_mem = 100000; ALTER ROLE|USER role_name {IN DATABASE name} SET configuration_parameter {TO|=} {value|DEFAULT}; ALTER ROLE|USER role_name {IN DATABASE name} SET configuration_parameter FROM CURRENT; ALTER ROLE|USER role_name {IN DATABASE name} RESET configuration_parameter; ALTER ROLE|USER role_name {IN DATABASE name} RESET ALL;

SCHEMA 操作

ALTER SCHEMA schema_name RENAME TO new_name; ALTER SCHEMA schema_name OWNER TO new_owner;

表操作

ALTER TABLE table_name RENAME TO new_name; ALTER TABLE table_name SET SCHEMA new_schema; ALTER TABLE table_name OWNER TO role_name; ALTER TABLE table_name SET TABLESPACE tablespace_name; ALTER TABLE table_name ADD column_name datatype; ALTER TABLE table_name DROP column_name; ALTER TABLE table_name ALTER column_name TYPE datatype; ALTER TABLE table_name RENAME column_name TO new_column_name; ALTER TABLE table_name ALTER column_name {SET|DROP} NOT NULL; ALTER TABLE table_name ALTER column_name SET DEFAULT expression; ALTER TABLE table_name RENAME CONSTRAINT constraint_name TO new_constraint_name; ALTER TABLE table_name ADD CONSTRAINT constraint_name PRIMARY KEY(id); ALTER TABLE table_name ADD CONSTRAINT constraint_name UNIQUE(id); ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK(id > 100); ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY(id) REFERENCES reftable(id); ALTER TABLE table_name DROP CONSTRAINT constraint_name;

總結(jié)

以上是生活随笔為你收集整理的PostgreSql 常用 ALTER 语句的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。