Section 7: overview, conventions, and miscellany
SET ROLE – set the current user identifier of the current session Synopsis SET [ SESSION | LOCAL ] ROLE rolename SET [ SESSION | LOCAL ] ROLE NONE RESET ROLE Description This command sets the current user identifier of the current SQL session to be rolename. The role name can be written as either…
SET CONSTRAINTS – set constraint checking modes for the current transaction Synopsis SET CONSTRAINTS { ALL | name [, …] } { DEFERRED | IMMEDIATE } Description 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 not checked until…
SET – change a run-time parameter Synopsis SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | ‘value’ | DEFAULT } SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT } Description The SET command changes run-time configuration parameters. Many of the run-time parameters listed…
SELECT INTO – define a new table from the results of a query Synopsis [ WITH [ RECURSIVE ] with_query [, …] ] SELECT [ ALL | DISTINCT [ ON ( expression [, …] ) ] ] * | expression [ [ AS ] output_name ] [, …] INTO [ TEMPORARY | TEMP ] […
SELECT, TABLE, WITH – retrieve rows from a table or view Synopsis [ WITH [ RECURSIVE ] with_query [, …] ] SELECT [ ALL | DISTINCT [ ON ( expression [, …] ) ] ] * | expression [ [ AS ] output_name ] [, …] [ FROM from_item [, …] ] [ WHERE condition…
SECURITY_LABEL – define or change a security label applied to an object Synopsis SECURITY LABEL [ FOR provider ] ON { TABLE object_name | COLUMN table_name.column_name | AGGREGATE agg_name (agg_type [, …] ) | DATABASE object_name | DOMAIN object_name | FOREIGN TABLE object_name FUNCTION function_name ( [ [ argmode ] [ argname ] argtype [,…
SAVEPOINT – define a new savepoint within the current transaction Synopsis SAVEPOINT savepoint_name Description 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 established to be rolled back, restoring the transaction state to what it was…
ROLLBACK TO SAVEPOINT – roll back to a savepoint Synopsis ROLLBACK [ WORK | TRANSACTION ] TO [ SAVEPOINT ] savepoint_name Description Roll back all commands that were executed after the savepoint was established. The savepoint remains valid and can be rolled back to again later, if needed. ROLLBACK TO SAVEPOINT implicitly destroys all savepoints…
ROLLBACK PREPARED – cancel a transaction that was earlier prepared for two-phase commit Synopsis ROLLBACK PREPARED transaction_id Description ROLLBACK PREPARED rolls back a transaction that is in prepared state. Parameters transaction_id The transaction identifier of the transaction that is to be rolled back. Notes To roll back a prepared transaction, you must be either the…
ROLLBACK – abort the current transaction Synopsis ROLLBACK [ WORK | TRANSACTION ] Description ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. Parameters WORK TRANSACTION Optional key words. They have no effect. Notes Use COMMIT [commit(7)] to successfully terminate a transaction. Issuing ROLLBACK when not…
REVOKE – remove access privileges Synopsis REVOKE [ GRANT OPTION FOR ] { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [,…] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, …] FROM { [ GROUP ] rolename | PUBLIC } [, …] [ CASCADE…
RESET – restore the value of a run-time parameter to the default value Synopsis RESET configuration_parameter RESET ALL Description RESET restores run-time parameters to their default values. RESET is an alternative spelling for SET configuration_parameter TO DEFAULT Refer to SET [set(7)] for details. The default value is defined as the value that the parameter would…
RELEASE SAVEPOINT – destroy a previously defined savepoint Synopsis RELEASE [ SAVEPOINT ] savepoint_name Description RELEASE SAVEPOINT destroys a savepoint previously defined in the current transaction. Destroying a savepoint makes it unavailable as a rollback point, but it has no other user visible behavior. It does not undo the effects of commands executed after the…
REINDEX – rebuild indexes Synopsis REINDEX { INDEX | TABLE | DATABASE | SYSTEM } name [ FORCE ] Description 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 become corrupted, and…
REASSIGN OWNED – change the ownership of database objects owned by a database role Synopsis REASSIGN OWNED BY old_role [, …] TO new_role Description REASSIGN OWNED instructs the system to change the ownership of the database objects owned by one of the old_roles, to new_role. Parameters old_role The name of a role. The ownership of…
PREPARE TRANSACTION – prepare the current transaction for two-phase commit Synopsis PREPARE TRANSACTION transaction_id Description 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 state is fully stored on disk, and there is a very high probability that it can…
PREPARE – prepare a statement for execution Synopsis PREPARE name [ ( datatype [, …] ) ] AS statement Description 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 statement is parsed, rewritten, and planned. When an…
PAM, pam – Pluggable Authentication Modules for Linux Description This manual is intended to offer a quick introduction to Linux-PAM. For more information the reader is directed to the Linux-PAM system administrators’ guide. Linux-PAM is a system of libraries that handle the authentication tasks of applications (services) on the system. The library provides a stable…
NOTIFY – generate a notification Synopsis NOTIFY name Description The NOTIFY command sends a notification event to each client application that has previously executed LISTEN name for the specified notification name in the current database. NOTIFY provides a simple form of signal or interprocess communication mechanism for a collection of processes accessing the same PostgreSQL…
MOVE – position a cursor Synopsis MOVE [ direction { FROM | IN } ] cursorname Description 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 the MOVE command are identical to those of the…