Search PostgreSQL documentation

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 DescriptionManual ChaptersPG18Description SECURITY LABEL applies a security label to a database object. An arbitrary number of security labels, one per label provider, can be associated with a given database object. Labe…Description DescriptionManual ChaptersPG18Description SELECT retrieves rows from zero or more tables. The general processing of SELECT is as follows: All queries in the WITH list are computed. These effectively serve as temporary ta…Description DescriptionManual ChaptersPG18Description SELECT INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal SELECT. The new table's columns have th…Description DescriptionManual ChaptersPG18Description SET CONSTRAINTS sets the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of each statement. DEFERRED constraints are …Description DescriptionManual ChaptersPG18Description This command sets the current user identifier of the current SQL session to be role_name. The role name can be written as either an identifier or a string literal. After SET ROLE…Description DescriptionManual ChaptersPG18Description This command sets the session user identifier and the current user identifier of the current SQL session to be user_name. The user name can be written as either an identifier or …Description DescriptionManual ChaptersPG18Description The SET TRANSACTION command sets the characteristics of the current transaction. It has no effect on any subsequent transactions. SET SESSION CHARACTERISTICS sets the default tra…Description