Search PostgreSQL documentation

DescriptionManual ChaptersPG18Description DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends. For more …Description DescriptionManual ChaptersPG18Description DECLARE allows a user to create cursors, which can be used to retrieve a small number of rows at a time out of a larger query. After the cursor is created, rows are fetched from …Description DescriptionManual ChaptersPG18Description DELETE deletes rows that satisfy the WHERE clause from the specified table. If the WHERE clause is absent, the effect is to delete all rows in the table. The result is a valid, b…Description DescriptionManual ChaptersPG18Description DISCARD releases internal resources associated with a database session. This command is useful for partially or fully resetting the session's state. There are several subcommands…Description DescriptionManual ChaptersPG18Description DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language. The code block is treated as though it were the body of a function…Description DescriptionManual ChaptersPG18Description DROP ACCESS METHOD removes an existing access method. Only superusers can drop access methods.Description DescriptionManual ChaptersPG18Description DROP OWNED drops all the objects within the current database that are owned by one of the specified roles. Any privileges granted to the given roles on objects in the current dat…Description DescriptionManual ChaptersPG18Description DROP AGGREGATE removes an existing aggregate function. To execute this command the current user must be the owner of the aggregate function.Description DescriptionManual ChaptersPG18Description DROP CAST removes a previously defined cast. To be able to drop a cast, you must own the source or the target data type. These are the same privileges that are required to create…Description DescriptionManual ChaptersPG18Description DROP COLLATION removes a previously defined collation. To be able to drop a collation, you must own the collation.Description DescriptionManual ChaptersPG18Description DROP CONVERSION removes a previously defined conversion. To be able to drop a conversion, you must own the conversion.Description DescriptionManual ChaptersPG18Description DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the directory containing the data. It can only be executed by the database owner. It c…Description DescriptionManual ChaptersPG18Description DROP DOMAIN removes a domain. Only the owner of a domain can remove it.Description DescriptionManual ChaptersPG18Description DROP EVENT TRIGGER removes an existing event trigger. To execute this command, the current user must be the owner of the event trigger.Description DescriptionManual ChaptersPG18Description DROP EXTENSION removes extensions from the database. Dropping an extension causes its member objects, and other explicitly dependent routines (see ALTER ROUTINE, the DEPENDS ON E…Description DescriptionManual ChaptersPG18Description DROP FOREIGN DATA WRAPPER removes an existing foreign-data wrapper. To execute this command, the current user must be the owner of the foreign-data wrapper.Description DescriptionManual ChaptersPG18Description DROP FOREIGN TABLE removes a foreign table. Only the owner of a foreign table can remove it.Description DescriptionManual ChaptersPG18Description DROP FUNCTION removes the definition of an existing function. To execute this command the user must be the owner of the function. The argument types to the function must be speci…Description DescriptionManual ChaptersPG18Description DROP GROUP is now an alias for DROP ROLE.Description DescriptionManual ChaptersPG18Description DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.Description DescriptionManual ChaptersPG18Description DROP LANGUAGE removes the definition of a previously registered procedural language. You must be a superuser or the owner of the language to use DROP LANGUAGE. Note As of Postgre…Description DescriptionManual ChaptersPG18Description DROP MATERIALIZED VIEW drops an existing materialized view. To execute this command you must be the owner of the materialized view.Description DescriptionManual ChaptersPG18Description DROP OPERATOR CLASS drops an existing operator class. To execute this command you must be the owner of the operator class. DROP OPERATOR CLASS does not drop any of the operators …Description DescriptionManual ChaptersPG18Description DROP OPERATOR drops an existing operator from the database system. To execute this command you must be the owner of the operator.Description DescriptionManual ChaptersPG18Description DROP OPERATOR FAMILY drops an existing operator family. To execute this command you must be the owner of the operator family. DROP OPERATOR FAMILY includes dropping any operator …Description DescriptionManual ChaptersPG18Description DROP POLICY removes the specified policy from the table. Note that if the last policy is removed for a table and the table still has row-level security enabled via ALTER TABLE, t…Description DescriptionManual ChaptersPG18Description DROP PROCEDURE removes the definition of one or more existing procedures. To execute this command the user must be the owner of the procedure(s). The argument types to the proced…Description DescriptionManual ChaptersPG18Description DROP PUBLICATION removes an existing publication from the database. A publication can only be dropped by its owner or a superuser.Description DescriptionManual ChaptersPG18Description DROP ROLE removes the specified role(s). To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must have CREATEROLE privilege and have been…Description DescriptionManual ChaptersPG18Description DROP ROUTINE removes the definition of one or more existing routines. The term “routine” includes aggregate functions, normal functions, and procedures. See under DROP AGGREGATE,…Description DescriptionManual ChaptersPG18Description DROP RULE drops a rewrite rule.Description DescriptionManual ChaptersPG18Description DROP SCHEMA removes schemas from the database. A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained object…Description DescriptionManual ChaptersPG18Description DROP SEQUENCE removes sequence number generators. A sequence can only be dropped by its owner or a superuser.Description DescriptionManual ChaptersPG18Description DROP SERVER removes an existing foreign server descriptor. To execute this command, the current user must be the owner of the server.Description DescriptionManual ChaptersPG18Description DROP STATISTICS removes statistics object(s) from the database. Only the statistics object's owner, the schema owner, or a superuser can drop a statistics object.Description DescriptionManual ChaptersPG18Description DROP SUBSCRIPTION removes a subscription from the database cluster. To execute this command the user must be the owner of the subscription. DROP SUBSCRIPTION cannot be executed i…Description DescriptionManual ChaptersPG18Description DROP TABLE removes tables from the database. Only the table owner, the schema owner, and superuser can drop a table. To empty a table of rows without destroying the table, use DE…Description DescriptionManual ChaptersPG18Description DROP TABLESPACE removes a tablespace from the system. A tablespace can only be dropped by its owner or a superuser. The tablespace must be empty of all database objects before it…Description DescriptionManual ChaptersPG18Description DROP TRANSFORM removes a previously defined transform. To be able to drop a transform, you must own the type and the language. These are the same privileges that are required to …Description DescriptionManual ChaptersPG18Description DROP TRIGGER removes an existing trigger definition. To execute this command, the current user must be the owner of the table for which the trigger is defined.Description