Search PostgreSQL documentation

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 DescriptionManual ChaptersPG18Description DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. To execute this command you must be the owner of the configuration.Description DescriptionManual ChaptersPG18Description DROP TEXT SEARCH DICTIONARY drops an existing text search dictionary. To execute this command you must be the owner of the dictionary.Description DescriptionManual ChaptersPG18Description DROP TEXT SEARCH PARSER drops an existing text search parser. You must be a superuser to use this command.Description DescriptionManual ChaptersPG18Description DROP TEXT SEARCH TEMPLATE drops an existing text search template. You must be a superuser to use this command.Description DescriptionManual ChaptersPG18Description DROP TYPE removes a user-defined data type. Only the owner of a type can remove it.Description DescriptionManual ChaptersPG18Description DROP USER is simply an alternate spelling of DROP ROLE.Description DescriptionManual ChaptersPG18Description DROP USER MAPPING removes an existing user mapping from foreign server. The owner of a foreign server can drop user mappings for that server for any user. Also, a user can drop a…Description DescriptionManual ChaptersPG18Description DROP VIEW drops an existing view. To execute this command you must be the owner of the view.Description DescriptionManual ChaptersPG18Description END commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs. This command is a PostgreSQL…Description DescriptionManual ChaptersPG18Description EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the prepared statement must have been created by a…Description DescriptionManual ChaptersPG18Description This command displays the execution plan that the PostgreSQL planner generates for the supplied statement. The execution plan shows how the table(s) referenced by the statement w…Description DescriptionManual ChaptersPG18Description FETCH retrieves rows using a previously-created cursor. A cursor has an associated position, which is used by FETCH. The cursor position can be before the first row of the query …Description DescriptionManual ChaptersPG18Description The GRANT command has two basic variants: one that grants privileges on a database object (table, column, view, foreign table, sequence, database, foreign-data wrapper, foreign s…Description DescriptionManual ChaptersPG18Description IMPORT FOREIGN SCHEMA creates foreign tables that represent tables existing on a foreign server. The new foreign tables will be owned by the user issuing the command and are crea…Description DescriptionManual ChaptersPG18Description INSERT inserts new rows into a table. One can insert one or more rows specified by value expressions, or zero or more rows resulting from a query. The target column names can be …Description DescriptionManual ChaptersPG18Description LISTEN registers the current session as a listener on the notification channel named channel. If the current session is already registered as a listener for this notification cha…Description DescriptionManual ChaptersPG18Description This command loads a shared library file into the PostgreSQL server's address space. If the file has been loaded already, the command does nothing. Shared library files that cont…Description DescriptionManual ChaptersPG18Description LOCK TABLE obtains a table-level lock, waiting if necessary for any conflicting locks to be released. If NOWAIT is specified, LOCK TABLE does not wait to acquire the desired lock…Description DescriptionManual ChaptersPG18Description MERGE performs actions that modify rows in the target table identified as target_table_name, using the data_source. MERGE provides a single SQL statement that can conditionally I…Description DescriptionManual ChaptersPG18Description MOVE repositions a cursor without retrieving any data. MOVE works exactly like the FETCH command, except it only positions the cursor and does not return rows. The parameters for…Description DescriptionManual ChaptersPG18Description The NOTIFY command sends a notification event together with an optional “payload” string to each client application that has previously executed LISTEN channel for the specified …Description DescriptionManual ChaptersPG18Description PREPARE TRANSACTION prepares the current transaction for two-phase commit. After this command, the transaction is no longer associated with the current session; instead, its stat…Description DescriptionManual ChaptersPG18Description PREPARE creates a prepared statement. A prepared statement is a server-side object that can be used to optimize performance. When the PREPARE statement is executed, the specified…Description DescriptionManual ChaptersPG18Description REASSIGN OWNED instructs the system to change the ownership of database objects owned by any of the old_roles to new_role.Description DescriptionManual ChaptersPG18Description REFRESH MATERIALIZED VIEW completely replaces the contents of a materialized view. To execute this command you must have the MAINTAIN privilege on the materialized view. The old …Description DescriptionManual ChaptersPG18Description REINDEX rebuilds an index using the data stored in the index's table, replacing the old copy of the index. There are several scenarios in which to use REINDEX: An index has becom…Description DescriptionManual ChaptersPG18Description RELEASE SAVEPOINT releases the named savepoint and all active savepoints that were created after the named savepoint, and frees their resources. All changes made since the creati…Description DescriptionManual ChaptersPG18Description RESET restores run-time parameters to their default values. RESET is an alternative spelling for SET configuration_parameter TO DEFAULT Refer to SET for details. The default valu…Description DescriptionManual ChaptersPG18Description The REVOKE command revokes previously granted privileges from one or more roles. The key word PUBLIC refers to the implicitly defined group of all roles. See the description of t…Description DescriptionManual ChaptersPG18Description ROLLBACK PREPARED rolls back a transaction that is in prepared state.Description DescriptionManual ChaptersPG18Description Roll back all commands that were executed after the savepoint was established and then start a new subtransaction at the same transaction level. The savepoint remains valid and c…Description DescriptionManual ChaptersPG18Description ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded.Description DescriptionManual ChaptersPG18Description SAVEPOINT establishes a new savepoint within the current transaction. A savepoint is a special mark inside a transaction that allows all commands that are executed after it was e…Description