Search PostgreSQL documentation

Aggregated LoggingManual ChaptersPG18Aggregated Logging With the --aggregate-interval option, a different format is used for the log files. Each log line describes one aggregation interval. It contains the following space-separ…Aggregated Logging ALIASManual ChaptersPG1841.3.2. ALIAS newname ALIAS FOR oldname; The ALIAS syntax is more general than is suggested in the previous section: you can declare an alias for any variable, not just function parameters. …ALIAS ALLManual ChaptersPG189.24.5. ALL expression operator ALL (subquery) The right-hand side is a parenthesized subquery, which must return exactly one column. The left-hand expression is evaluated and compared to ea…ALL ALL (array)Manual ChaptersPG189.25.4. ALL (array) expression operator ALL (array expression) The right-hand side is a parenthesized expression, which must yield an array value. The left-hand expression is evaluated and c…ALL (array) ALLOCATE DESCRIPTORManual ChaptersPG18ALLOCATE DESCRIPTOR ALLOCATE DESCRIPTOR — allocate an SQL descriptor area Synopsis ALLOCATE DESCRIPTOR nameALLOCATE DESCRIPTOR ALTER AGGREGATEManual ChaptersPG18ALTER AGGREGATE ALTER AGGREGATE — change the definition of an aggregate function Synopsis ALTER AGGREGATE name ( aggregate_signature ) RENAME TO new_name ALTER AGGREGATE name ( aggregate_sig…ALTER AGGREGATE ALTER COLLATIONManual ChaptersPG18ALTER COLLATION ALTER COLLATION — change the definition of a collation Synopsis ALTER COLLATION name REFRESH VERSION ALTER COLLATION name RENAME TO new_name ALTER COLLATION name OWNER TO { n…ALTER COLLATION ALTER CONVERSIONManual ChaptersPG18ALTER CONVERSION ALTER CONVERSION — change the definition of a conversion Synopsis ALTER CONVERSION name RENAME TO new_name ALTER CONVERSION name OWNER TO { new_owner | CURRENT_ROLE | CURREN…ALTER CONVERSION ALTER DATABASEManual ChaptersPG18ALTER DATABASE ALTER DATABASE — change a database Synopsis ALTER DATABASE name [ [ WITH ] option [ ... ] ] where option can be: ALLOW_CONNECTIONS allowconn CONNECTION LIMIT connlimit IS_TEMP…ALTER DATABASE ALTER DEFAULT PRIVILEGESManual ChaptersPG18ALTER DEFAULT PRIVILEGES ALTER DEFAULT PRIVILEGES — define default access privileges Synopsis ALTER DEFAULT PRIVILEGES [ FOR { ROLE | USER } target_role [, ...] ] [ IN SCHEMA schema_name [, …ALTER DEFAULT PRIVILEGES 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 RULEManual ChaptersPG18ALTER RULE ALTER RULE — change the definition of a rule Synopsis ALTER RULE name ON table_name RENAME TO new_nameALTER RULE ALTER SCHEMAManual ChaptersPG18ALTER SCHEMA ALTER SCHEMA — change the definition of a schema Synopsis ALTER SCHEMA name RENAME TO new_name ALTER SCHEMA name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USE…ALTER SCHEMA ALTER SEQUENCEManual ChaptersPG18ALTER SEQUENCE ALTER SEQUENCE — change the definition of a sequence generator Synopsis ALTER SEQUENCE [ IF EXISTS ] name [ AS data_type ] [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue |…ALTER SEQUENCE ALTER SERVERManual ChaptersPG18ALTER SERVER ALTER SERVER — change the definition of a foreign server Synopsis ALTER SERVER name [ VERSION 'new_version' ] [ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] ) ] ALTE…ALTER SERVER ALTER STATISTICSManual ChaptersPG18ALTER STATISTICS ALTER STATISTICS — change the definition of an extended statistics object Synopsis ALTER STATISTICS name OWNER TO { new_owner | CURRENT_ROLE | CURRENT_USER | SESSION_USER } …ALTER STATISTICS ALTER SUBSCRIPTIONManual ChaptersPG18ALTER SUBSCRIPTION ALTER SUBSCRIPTION — change the definition of a subscription Synopsis ALTER SUBSCRIPTION name CONNECTION 'conninfo' ALTER SUBSCRIPTION name SET PUBLICATION publication_nam…ALTER SUBSCRIPTION ALTER SYSTEMManual ChaptersPG18ALTER SYSTEM ALTER SYSTEM — change a server configuration parameter Synopsis ALTER SYSTEM SET configuration_parameter { TO | = } { value [, ...] | DEFAULT } ALTER SYSTEM RESET configuration_…ALTER SYSTEM ALTER TABLEManual ChaptersPG18ALTER TABLE ALTER TABLE — change the definition of a table SynopsisALTER TABLE ALTER TABLESPACEManual ChaptersPG18ALTER TABLESPACE ALTER TABLESPACE — change the definition of a tablespace Synopsis ALTER TABLESPACE name RENAME TO new_name ALTER TABLESPACE name OWNER TO { new_owner | CURRENT_ROLE | CURREN…ALTER TABLESPACE ALTER TEXT SEARCH CONFIGURATIONManual ChaptersPG18ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH CONFIGURATION — change the definition of a text search configuration Synopsis ALTER TEXT SEARCH CONFIGURATION name ADD MAPPING FOR token_typ…ALTER TEXT SEARCH CONFIGURATION ALTER TEXT SEARCH DICTIONARYManual ChaptersPG18ALTER TEXT SEARCH DICTIONARY ALTER TEXT SEARCH DICTIONARY — change the definition of a text search dictionary Synopsis ALTER TEXT SEARCH DICTIONARY name ( option [ = value ] [, ... ] ) ALTER…ALTER TEXT SEARCH DICTIONARY