Search PostgreSQL documentation

DescriptionManual ChaptersPG18Description ALTER LARGE OBJECT changes the definition of a large object. You must own the large object to use ALTER LARGE OBJECT. To alter the owner, you must also be able to SET ROLE to the…Description DescriptionManual ChaptersPG18Description ALTER MATERIALIZED VIEW changes various auxiliary properties of an existing materialized view. You must own the materialized view to use ALTER MATERIALIZED VIEW. To change a mate…Description DescriptionManual ChaptersPG18Description ALTER OPERATOR CLASS changes the definition of an operator class. You must own the operator class to use ALTER OPERATOR CLASS. To alter the owner, you must be able to SET ROLE to…Description DescriptionManual ChaptersPG18Description ALTER OPERATOR changes the definition of an operator. You must own the operator to use ALTER OPERATOR. To alter the owner, you must be able to SET ROLE to the new owning role, an…Description DescriptionManual ChaptersPG18Description ALTER OPERATOR FAMILY changes the definition of an operator family. You can add operators and support functions to the family, remove them from the family, or change the family's…Description DescriptionManual ChaptersPG18Description ALTER POLICY changes the definition of an existing row-level security policy. Note that ALTER POLICY only allows the set of roles to which the policy applies and the USING and WI…Description DescriptionManual ChaptersPG18Description ALTER PROCEDURE changes the definition of a procedure. You must own the procedure to use ALTER PROCEDURE. To change a procedure's schema, you must also have CREATE privilege on t…Description DescriptionManual ChaptersPG18Description The command ALTER PUBLICATION can change the attributes of a publication. The first three variants change which tables/schemas are part of the publication. The SET clause will re…Description DescriptionManual ChaptersPG18Description ALTER ROLE changes the attributes of a PostgreSQL role. The first variant of this command listed in the synopsis can change many of the role attributes that can be specified in C…Description DescriptionManual ChaptersPG18Description ALTER ROUTINE changes the definition of a routine, which can be an aggregate function, a normal function, or a procedure. See under ALTER AGGREGATE, ALTER FUNCTION, and ALTER PRO…Description DescriptionManual ChaptersPG18Description ALTER RULE changes properties of an existing rule. Currently, the only available action is to change the rule's name. To use ALTER RULE, you must own the table or view that the r…Description DescriptionManual ChaptersPG18Description 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 alte…Description DescriptionManual ChaptersPG18Description ALTER SEQUENCE changes the parameters of an existing sequence generator. Any parameters not specifically set in the ALTER SEQUENCE command retain their prior settings. You must o…Description DescriptionManual ChaptersPG18Description ALTER SERVER changes the definition of a foreign server. The first form changes the server version string or the generic options of the server (at least one clause is required). …Description DescriptionManual ChaptersPG18Description ALTER STATISTICS changes the parameters of an existing extended statistics object. Any parameters not specifically set in the ALTER STATISTICS command retain their prior settings…Description DescriptionManual ChaptersPG18Description ALTER SUBSCRIPTION can change most of the subscription properties that can be specified in CREATE SUBSCRIPTION. You must own the subscription to use ALTER SUBSCRIPTION. To rename…Description DescriptionManual ChaptersPG18Description ALTER SYSTEM is used for changing server configuration parameters across the entire database cluster. It can be more convenient than the traditional method of manually editing th…Description DescriptionManual ChaptersPG18Description ALTER TABLE changes the definition of an existing table. There are several subforms described below. Note that the lock level required may differ for each subform. An ACCESS EXCL…Description DescriptionManual ChaptersPG18Description ALTER TABLESPACE can be used to change the definition of a tablespace. You must own the tablespace to change the definition of a tablespace. To alter the owner, you must also be …Description DescriptionManual ChaptersPG18Description ALTER TRIGGER changes properties of an existing trigger. The RENAME clause changes the name of the given trigger without otherwise changing the trigger definition. If the table t…Description DescriptionManual ChaptersPG18Description ALTER TEXT SEARCH CONFIGURATION changes the definition of a text search configuration. You can modify its mappings from token types to dictionaries, or change the configuration's…Description DescriptionManual ChaptersPG18Description ALTER TEXT SEARCH DICTIONARY changes the definition of a text search dictionary. You can change the dictionary's template-specific options, or change the dictionary's name or own…Description DescriptionManual ChaptersPG18Description 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 us…Description DescriptionManual ChaptersPG18Description ALTER TEXT SEARCH TEMPLATE changes the definition of a text search template. Currently, the only supported functionality is to change the template's name. You must be a superuser…Description DescriptionManual ChaptersPG18Description ALTER TYPE changes the definition of an existing type. There are several subforms: OWNER This form changes the owner of the type. RENAME This form changes the name of the type. S…Description DescriptionManual ChaptersPG18Description ALTER USER is now an alias for ALTER ROLE.Description DescriptionManual ChaptersPG18Description ALTER USER MAPPING changes the definition of a user mapping. The owner of a foreign server can alter user mappings for that server for any user. Also, a user can alter a user map…Description DescriptionManual ChaptersPG18Description ALTER VIEW changes various auxiliary properties of a view. (If you want to modify the view's defining query, use CREATE OR REPLACE VIEW.) You must own the view to use ALTER VIEW.…Description DescriptionManual ChaptersPG18Description ANALYZE collects statistics about the contents of tables in the database, and stores the results in the pg_statistic system catalog. Subsequently, the query planner uses these st…Description DescriptionManual ChaptersPG18Description BEGIN initiates a transaction block, that is, all statements after a BEGIN command will be executed in a single transaction until an explicit COMMIT or ROLLBACK is given. By defa…Description DescriptionManual ChaptersPG18Description CALL executes a procedure. If the procedure has any output parameters, then a result row will be returned, containing the values of those parameters.Description DescriptionManual ChaptersPG18Description A checkpoint is a point in the write-ahead log sequence at which all data files have been updated to reflect the information in the log. All data files will be flushed to disk. R…Description DescriptionManual ChaptersPG18Description CLOSE frees the resources associated with an open cursor. After the cursor is closed, no subsequent operations are allowed on it. A cursor should be closed when it is no longer n…Description DescriptionManual ChaptersPG18Description CLUSTER instructs PostgreSQL to cluster the table specified by table_name based on the index specified by index_name. The index must already have been defined on table_name. When…Description DescriptionManual ChaptersPG18Description COMMENT stores, replaces, or removes the comment on a database object. Only one comment string is stored for each object. Issuing a new COMMENT command for the same object replac…Description DescriptionManual ChaptersPG18Description COMMIT PREPARED commits a transaction that is in prepared state.Description DescriptionManual ChaptersPG18Description COMMIT commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.Description DescriptionManual ChaptersPG18Description COPY moves data between PostgreSQL tables and standard file-system files. COPY TO copies the contents of a table to a file, while COPY FROM copies data from a file to a table (ap…Description DescriptionManual ChaptersPG18Description CREATE ACCESS METHOD creates a new access method. The access method name must be unique within the database. Only superusers can define new access methods.Description DescriptionManual ChaptersPG18Description CREATE AGGREGATE defines a new aggregate function. CREATE OR REPLACE AGGREGATE will either define a new aggregate function or replace an existing definition. Some basic and commo…Description