UPDATE – update rows of a table Synopsis UPDATE [ ONLY ] table [ [ AS ] alias ] SET { column = { expression | DEFAULT } | ( column [, …] ) = ( { expression | DEFAULT } [, …] ) } [, …] [ FROM fromlist ] [ WHERE condition |…
UNLISTEN – stop listening for a notification Synopsis UNLISTEN { name | * } Description UNLISTEN is used to remove an existing registration for NOTIFY events. UNLISTEN cancels any existing registration of the current PostgreSQL session as a listener on the notification name. The special wildcard * cancels all listener registrations for the current session….
TRUNCATE – empty a table or set of tables Synopsis TRUNCATE [ TABLE ] [ ONLY ] name [, … ] [ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ] Description TRUNCATE quickly removes all rows from a set of tables. It has the same effect as an unqualified DELETE on each…
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…
standards – C and UNIX Standards Description The CONFORMING TO section that appears in many manual pages identifies various standards to which the documented interface conforms. The following list briefly describes these standards. V7 Version 7 (also known as Seventh Edition) UNIX, released by AT&T/Bell Labs in 1979. After this point, UNIX systems diverged into…
START TRANSACTION – start a transaction block Synopsis START TRANSACTION [ transaction_mode [, …] ] where transaction_mode is one of: ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED } READ WRITE | READ ONLY Description This command begins a new transaction block. If the isolation level or read/write mode is…
SHOW – show the value of a run-time parameter Synopsis SHOW name SHOW ALL Description SHOW will display the current setting of run-time parameters. These variables can be set using the SET statement, by editing the postgresql.conf configuration file, through the PGOPTIONS environmental variable (when using libpq or a libpq-based application), or through command-line flags…
SET TRANSACTION – set the characteristics of the current transaction Synopsis SET TRANSACTION transaction_mode [, …] SET SESSION CHARACTERISTICS AS TRANSACTION transaction_mode [, …] where transaction_mode is one of: ISOLATION LEVEL { SERIALIZABLE | REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED } READ WRITE | READ ONLY Description The SET TRANSACTION command sets the…
SET SESSION AUTHORIZATION – set the session user identifier and the current user identifier of the current session Synopsis SET [ SESSION | LOCAL ] SESSION AUTHORIZATION username SET [ SESSION | LOCAL ] SESSION AUTHORIZATION DEFAULT RESET SESSION AUTHORIZATION Description This command sets the session user identifier and the current user identifier of the…
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…