Search PostgreSQL documentation

DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH DICTIONARY creates a new text search dictionary. A text search dictionary specifies a way of recognizing interesting or uninteresting words for searching. A di…Description DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH PARSER creates a new text search parser. A text search parser defines a method for splitting a text string into tokens and assigning types (categories) to the …Description DescriptionManual ChaptersPG18Description CREATE TEXT SEARCH TEMPLATE creates a new text search template. Text search templates define the functions that implement text search dictionaries. A template is not useful by it…Description DescriptionManual ChaptersPG18Description CREATE TYPE registers a new data type for use in the current database. The user who defines a type becomes its owner. If a schema name is given then the type is created in the sp…Description DescriptionManual ChaptersPG18Description CREATE USER is now an alias for CREATE ROLE. The only difference is that when the command is spelled CREATE USER, LOGIN is assumed by default, whereas NOLOGIN is assumed when the…Description DescriptionManual ChaptersPG18Description CREATE USER MAPPING defines a mapping of a user to a foreign server. A user mapping typically encapsulates connection information that a foreign-data wrapper uses together with t…Description DescriptionManual ChaptersPG18Description CREATE VIEW defines a view of a query. The view is not physically materialized. Instead, the query is run every time the view is referenced in a query. CREATE OR REPLACE VIEW is …Description 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