Section 7: overview, conventions, and miscellany
ALTER TEXT SEARCH PARSER – change the definition of a text search parser Synopsis ALTER TEXT SEARCH PARSER name RENAME TO newname Description ALTER TEXT SEARCH PARSER changes the definition of a text search parser. Currently, the only supported functionality is to change the parser’s name. You must be a superuser to use ALTER TEXT…
ALTER TEXT SEARCH DICTIONARY – change the definition of a text search dictionary Synopsis ALTER TEXT SEARCH DICTIONARY name ( option [ = value ] [, … ] ) ALTER TEXT SEARCH DICTIONARY name RENAME TO newname ALTER TEXT SEARCH DICTIONARY name OWNER TO newowner Description ALTER TEXT SEARCH DICTIONARY changes the definition of a…
ALTER TEXT SEARCH CONFIGURATION – change the definition of a text search configuration Synopsis ALTER TEXT SEARCH CONFIGURATION name ADD MAPPING FOR token_type [, … ] WITH dictionary_name [, … ] ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING FOR token_type [, … ] WITH dictionary_name [, … ] ALTER TEXT SEARCH CONFIGURATION name ALTER MAPPING…
ALTER TABLESPACE – change the definition of a tablespace Synopsis ALTER TABLESPACE name RENAME TO newname ALTER TABLESPACE name OWNER TO newowner Description ALTER TABLESPACE changes the definition of a tablespace. You must own the tablespace to use ALTER TABLESPACE. To alter the owner, you must also be a direct or indirect member of the…
ALTER TABLE – change the definition of a table Synopsis 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…
ALTER SERVER – change the definition of a foreign server Synopsis ALTER SERVER servername [ VERSION ‘newversion’ ] [ OPTIONS ( [ ADD | SET | DROP ] option [‘value’] [, … ] ) ] ALTER SERVER servername OWNER TO new_owner Description ALTER SERVER changes the definition of a foreign server. The first form changes…
ALTER SEQUENCE – change the definition of a sequence generator Synopsis ALTER SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ RESTART [ [ WITH ] restart ] ] [ CACHE cache ]…
ALTER SCHEMA – change the definition of a schema Synopsis ALTER SCHEMA name RENAME TO newname ALTER SCHEMA name OWNER TO newowner Description ALTER SCHEMA changes the definition of a schema. You must own the schema to use ALTER SCHEMA. To rename a schema you must also have the CREATE privilege for the database. To…
ALTER ROLE – change a database role Synopsis ALTER ROLE name [ [ WITH ] option [ … ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | CREATEUSER | NOCREATEUSER | INHERIT | NOINHERIT | LOGIN | NOLOGIN | CONNECTION LIMIT connlimit | [ ENCRYPTED |…
ALTER OPERATOR FAMILY – change the definition of an operator family Synopsis ALTER OPERATOR FAMILY name USING index_method ADD { OPERATOR strategy_number operator_name ( op_type, op_type ) | FUNCTION support_number [ ( op_type [ , op_type ] ) ] funcname ( argument_type [, …] ) } [, … ] ALTER OPERATOR FAMILY name USING index_method…
ALTER OPERATOR CLASS – change the definition of an operator class Synopsis ALTER OPERATOR CLASS name USING index_method RENAME TO newname ALTER OPERATOR CLASS name USING index_method OWNER TO newowner Description ALTER OPERATOR CLASS changes the definition of an operator class. You must own the operator class to use ALTER OPERATOR CLASS. To alter the…
ALTER OPERATOR – change the definition of an operator Synopsis ALTER OPERATOR name ( { lefttype | NONE } , { righttype | NONE } ) OWNER TO newowner Description ALTER OPERATOR changes the definition of an operator. The only currently available functionality is to change the owner of the operator. You must own the…
ALTER_LARGE_OBJECT – change the definition of a large object Synopsis ALTER LARGE OBJECT large_object_oid OWNER TO new_owner Description ALTER LARGE OBJECT changes the definition of a large object. The only functionality is to assign a new owner. You must be superuser or owner of the large object to use ALTER LARGE OBJECT. Parameters large_object_oid OID…
ALTER LANGUAGE – change the definition of a procedural language Synopsis ALTER [ PROCEDURAL ] LANGUAGE name RENAME TO newname ALTER [ PROCEDURAL ] LANGUAGE name OWNER TO new_owner Description ALTER LANGUAGE changes the definition of a procedural language. The only functionality is to rename the language or assign a new owner. You must be…
ALTER INDEX – change the definition of an index Synopsis ALTER INDEX name RENAME TO new_name ALTER INDEX name SET TABLESPACE tablespace_name ALTER INDEX name SET ( storage_parameter = value [, … ] ) ALTER INDEX name RESET ( storage_parameter [, … ] ) Description ALTER INDEX changes the definition of an existing index. There…
ALTER GROUP – change role name or membership Synopsis ALTER GROUP groupname ADD USER username [, … ] ALTER GROUP groupname DROP USER username [, … ] ALTER GROUP groupname RENAME TO newname Description ALTER GROUP changes the attributes of a user group. This is an obsolete command, though still accepted for backwards compatibility, because…
ALTER FUNCTION – change the definition of a function Synopsis ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, …] ] ) action [ … ] [ RESTRICT ] ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, …] ] ) RENAME TO new_name ALTER FUNCTION name…
ALTER_FOREIGN_TABLE – change the definition of a foreign table Synopsis ALTER FOREIGN TABLE [ IF EXISTS ] name action [, … ] ALTER FOREIGN TABLE [ IF EXISTS ] name RENAME [ COLUMN ] column_name TO new_column_name ALTER FOREIGN TABLE [ IF EXISTS ] name RENAME TO new_name ALTER FOREIGN TABLE [ IF EXISTS ]…
ALTER FOREIGN DATA WRAPPER – change the definition of a foreign-data wrapper Synopsis ALTER FOREIGN DATA WRAPPER name [ VALIDATOR valfunction | NO VALIDATOR ] [ OPTIONS ( [ ADD | SET | DROP ] option [‘value’] [, … ]) ] ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner Description ALTER FOREIGN DATA WRAPPER changes…
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 name ADD member_object ALTER EXTENSION name DROP member_object where member_object is: AGGREGATE agg_name (agg_type [, …] ) | CAST (source_type AS target_type) | COLLATION object_name | CONVERSION object_name | DOMAIN…