Search PostgreSQL documentation

ALTER DOMAINManual ChaptersPG18ALTER DOMAIN ALTER DOMAIN — change the definition of a domain Synopsis ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET | DROP } NOT NULL ALTER DOMAIN name…ALTER DOMAIN ALTER DOMAINSQL CommandsReferenceALTER DOMAIN Types & Operators 10 change the definition of a domain ALTER DOMAIN name { SET DEFAULT expression | DROP DEFAULT } ALTER DOMAIN name { SET | DROP } NOT NULL ALTER DOMAIN name AD…SQL Commands · Types & Operators ALTER EVENT TRIGGERManual ChaptersPG18ALTER EVENT TRIGGER ALTER EVENT TRIGGER — change the definition of an event trigger Synopsis ALTER EVENT TRIGGER name DISABLE ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ] ALTER EVENT…ALTER EVENT TRIGGER ALTER EVENT TRIGGERSQL CommandsReferenceALTER EVENT TRIGGER Triggers & Rules 10 change the definition of an event trigger ALTER EVENT TRIGGER name DISABLE ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ] ALTER EVENT TRIGGER na…SQL Commands · Triggers & Rules ALTER EXTENSIONManual ChaptersPG18ALTER EXTENSION ALTER EXTENSION — change the definition of an extension Synopsis ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET SCHEMA new_schema ALTER EXTENSION nam…ALTER EXTENSION ALTER EXTENSIONSQL CommandsReferenceALTER EXTENSION Extensions & Access Methods 10 change the definition of an extension ALTER EXTENSION name UPDATE [ TO new_version ] ALTER EXTENSION name SET SCHEMA new_schema ALTER EXTENSION…SQL Commands · Extensions & Access Methods ALTER FOREIGN DATA WRAPPERManual ChaptersPG18ALTER FOREIGN DATA WRAPPER ALTER FOREIGN DATA WRAPPER — change the definition of a foreign-data wrapper Synopsis ALTER FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ V…ALTER FOREIGN DATA WRAPPER ALTER FOREIGN DATA WRAPPERSQL CommandsReferenceALTER FOREIGN DATA WRAPPER Foreign Data 10 change the definition of a foreign-data wrapper ALTER FOREIGN DATA WRAPPER name [ HANDLER handler_function | NO HANDLER ] [ VALIDATOR validator_fun…SQL Commands · Foreign Data ALTER FOREIGN TABLEManual ChaptersPG18ALTER FOREIGN TABLE ALTER FOREIGN TABLE — change the definition of a foreign table Synopsis ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER FOREIGN TABLE [ IF EXI…ALTER FOREIGN TABLE ALTER FOREIGN TABLESQL CommandsReferenceALTER FOREIGN TABLE Foreign Data 10 change the definition of a foreign table ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] name [ * ] action [, ... ] ALTER FOREIGN TABLE [ IF EXISTS ] [ ONLY ] …SQL Commands · Foreign Data ALTER FUNCTIONManual ChaptersPG18ALTER FUNCTION ALTER FUNCTION — change the definition of a function Synopsis ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER FUNCTIO…ALTER FUNCTION ALTER FUNCTIONSQL CommandsReferenceALTER FUNCTION Functions & Procedures 10 change the definition of a function ALTER FUNCTION name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER FUNCTIO…SQL Commands · Functions & Procedures ALTER GROUPManual ChaptersPG18ALTER GROUP ALTER GROUP — change role name or membership Synopsis ALTER GROUP role_specification ADD USER user_name [, ... ] ALTER GROUP role_specification DROP USER user_name [, ... ] where…ALTER GROUP ALTER GROUPSQL CommandsReferenceALTER GROUP Roles & Privileges 10 change role name or membership ALTER GROUP role_specification ADD USER user_name [, ... ] ALTER GROUP role_specification DROP USER user_name [, ... ] where…SQL Commands · Roles & Privileges ALTER INDEXManual ChaptersPG18ALTER INDEX ALTER INDEX — change the definition of an index Synopsis ALTER INDEX [ IF EXISTS ] name RENAME TO new_name ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name ALTER IND…ALTER INDEX ALTER INDEXSQL CommandsReferenceALTER INDEX Indexes & Statistics 10 change the definition of an index ALTER INDEX [ IF EXISTS ] name RENAME TO new_name ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name ALTER IN…SQL Commands · Indexes & Statistics ALTER LANGUAGEManual ChaptersPG18ALTER LANGUAGE ALTER LANGUAGE — change the definition of a procedural language Synopsis ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { ne…ALTER LANGUAGE ALTER LANGUAGESQL CommandsReferenceALTER LANGUAGE Functions & Procedures 10 change the definition of a procedural language ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO new_name ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO { ne…SQL Commands · Functions & Procedures ALTER LARGE OBJECTManual ChaptersPG18ALTER LARGE OBJECT ALTER LARGE OBJECT — change the definition of a large object Synopsis ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER…ALTER LARGE OBJECT ALTER LARGE OBJECTSQL CommandsReferenceALTER LARGE OBJECT Other Objects 10 change the definition of a large object ALTER LARGE OBJECT large_object_oid OWNER TO { new_owner | CURRENT_USER | SESSION_USER } ALTER LARGE OBJECT change…SQL Commands · Other Objects ALTER MATERIALIZED VIEWManual ChaptersPG18ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEW — change the definition of a materialized view Synopsis ALTER MATERIALIZED VIEW [ IF EXISTS ] name action [, ... ] ALTER MATERIALIZED VIEW nam…ALTER MATERIALIZED VIEW ALTER MATERIALIZED VIEWSQL CommandsReferenceALTER MATERIALIZED VIEW Tables & Views 10 change the definition of a materialized view ALTER MATERIALIZED VIEW [ IF EXISTS ] name action [, ... ] ALTER MATERIALIZED VIEW name DEPENDS ON EXTE…SQL Commands · Tables & Views ALTER OPERATORManual ChaptersPG18ALTER OPERATOR ALTER OPERATOR — change the definition of an operator Synopsis ALTER OPERATOR name ( { left_type | NONE } , right_type ) OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | S…ALTER OPERATOR ALTER OPERATORSQL CommandsReferenceALTER OPERATOR Types & Operators 10 change the definition of an operator ALTER OPERATOR name ( { left_type | NONE } , { right_type | NONE } ) OWNER TO { new_owner | CURRENT_USER | SESSION_US…SQL Commands · Types & Operators ALTER OPERATOR CLASSManual ChaptersPG18ALTER OPERATOR CLASS ALTER OPERATOR CLASS — change the definition of an operator class Synopsis ALTER OPERATOR CLASS name USING index_method RENAME TO new_name ALTER OPERATOR CLASS name USIN…ALTER OPERATOR CLASS ALTER OPERATOR CLASSSQL CommandsReferenceALTER OPERATOR CLASS Types & Operators 10 change the definition of an operator class ALTER OPERATOR CLASS name USING index_method RENAME TO new_name ALTER OPERATOR CLASS name USING index_me…SQL Commands · Types & Operators ALTER OPERATOR FAMILYManual ChaptersPG18ALTER OPERATOR FAMILY ALTER OPERATOR FAMILY — change the definition of an operator family Synopsis ALTER OPERATOR FAMILY name USING index_method ADD { OPERATOR strategy_number operator_name …ALTER OPERATOR FAMILY ALTER OPERATOR FAMILYSQL CommandsReferenceALTER OPERATOR FAMILY Types & Operators 10 change the definition of an operator family ALTER OPERATOR FAMILY name USING index_method ADD { OPERATOR strategy_number operator_name ( op_type, o…SQL Commands · Types & Operators ALTER POLICYManual ChaptersPG18ALTER POLICY ALTER POLICY — change the definition of a row-level security policy Synopsis ALTER POLICY name ON table_name RENAME TO new_name ALTER POLICY name ON table_name [ TO { role_name …ALTER POLICY ALTER POLICYSQL CommandsReferenceALTER POLICY Roles & Privileges 10 change the definition of a row level security policy ALTER POLICY name ON table_name RENAME TO new_name ALTER POLICY name ON table_name [ TO { role_name |…SQL Commands · Roles & Privileges ALTER PROCEDUREManual ChaptersPG18ALTER PROCEDURE ALTER PROCEDURE — change the definition of a procedure Synopsis ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER PRO…ALTER PROCEDURE ALTER PROCEDURESQL CommandsReferenceALTER PROCEDURE Functions & Procedures 11 change the definition of a procedure ALTER PROCEDURE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER PROC…SQL Commands · Functions & Procedures ALTER PROPERTY GRAPHSQL CommandsReferenceALTER PROPERTY GRAPH Other Objects 19 change the definition of an SQL-property graph ALTER PROPERTY GRAPH name ADD [ {VERTEX|NODE} TABLES ( vertex_table_definition [, ...] ) ] [ {EDGE|RELATI…SQL Commands · Other Objects ALTER PUBLICATIONManual ChaptersPG18ALTER PUBLICATION ALTER PUBLICATION — change the definition of a publication Synopsis ALTER PUBLICATION name ADD publication_object [, ...] ALTER PUBLICATION name SET publication_object [, .…ALTER PUBLICATION ALTER PUBLICATIONSQL CommandsReferenceALTER PUBLICATION Logical Replication 10 change the definition of a publication ALTER PUBLICATION name ADD TABLE [ ONLY ] table_name [ * ] [, ...] ALTER PUBLICATION name SET TABLE [ ONLY ] t…SQL Commands · Logical Replication ALTER ROLEManual ChaptersPG18ALTER ROLE ALTER ROLE — change a database role Synopsis ALTER ROLE role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROL…ALTER ROLE ALTER ROLESQL CommandsReferenceALTER ROLE Roles & Privileges 10 change a database role ALTER ROLE role_specification [ WITH ] option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATER…SQL Commands · Roles & Privileges ALTER ROUTINEManual ChaptersPG18ALTER ROUTINE ALTER ROUTINE — change the definition of a routine Synopsis ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER ROUTINE nam…ALTER ROUTINE ALTER ROUTINESQL CommandsReferenceALTER ROUTINE Functions & Procedures 11 change the definition of a routine ALTER ROUTINE name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] action [ ... ] [ RESTRICT ] ALTER ROUTINE na…SQL Commands · Functions & Procedures ALTER RULEManual ChaptersPG18ALTER RULE ALTER RULE — change the definition of a rule Synopsis ALTER RULE name ON table_name RENAME TO new_nameALTER RULE