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…
LOCK – lock a table Synopsis LOCK [ TABLE ] [ ONLY ] name [, …] [ IN lockmode MODE ] [ NOWAIT ] where lockmode is one of: ACCESS SHARE | ROW SHARE | ROW EXCLUSIVE | SHARE UPDATE EXCLUSIVE | SHARE | SHARE ROW EXCLUSIVE | EXCLUSIVE | ACCESS EXCLUSIVE Description LOCK TABLE…
LOAD – load a shared library file Synopsis LOAD ‘filename’ Description 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 contain C functions are automatically loaded whenever one of their functions is called. Therefore, an explicit…
LISTEN – listen for a notification Synopsis LISTEN name Description LISTEN registers the current session as a listener on the notification condition name. If the current session is already registered as a listener for this notification condition, nothing is done. Whenever the command NOTIFY name is invoked, either by this session or another one connected…
LDP – Intro to the Linux Documentation Project, with help, guides and documents Synopsis The Linux Documentation Project (LDP) provides a variety of free documentation resources including guides, FAQs, HOWTOs, and man-pages to the Linux community. Authors The various documents in the LDP archives are maintained by individual authors, and are listed in the beginning…
INSERT – create new rows in a table Synopsis INSERT INTO table [ ( column [, …] ) ] { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, …] ) [, …] | query } [ RETURNING * | output_expression [ [ AS ] output_name ] [, …] ] Description INSERT inserts…
GRANT – define access privileges Synopsis GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } [,…] | ALL [ PRIVILEGES ] } ON [ TABLE ] tablename [, …] TO { [ GROUP ] rolename | PUBLIC } [, …] [ WITH GRANT OPTION ] GRANT {…
GNUstep – A free implementation of the OpenStep standard Description GNUstep provides an Object-Oriented application development framework and toolset for use on a wide variety of computer platforms. GNUstep is based on the original OpenStep specification provided by NeXT, Inc. (now Apple and called Cocoa). GNUstep is written in Objective-C, an object-oriented superset of the…
FETCH – retrieve rows from a query using a cursor Synopsis FETCH [ direction { FROM | IN } ] cursorname where direction can be empty or one of: NEXT PRIOR FIRST LAST ABSOLUTE count RELATIVE count count ALL FORWARD FORWARD count FORWARD ALL BACKWARD BACKWARD count BACKWARD ALL Description FETCH retrieves rows using a…
EXPLAIN – show the execution plan of a statement Synopsis EXPLAIN [ ANALYZE ] [ VERBOSE ] statement Description 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 will be scanned — by plain sequential scan, index scan,…
EXECUTE – execute a prepared statement Synopsis EXECUTE name [ ( parameter [, …] ) ] Description 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 PREPARE statement executed earlier in the current session. If…
END – commit the current transaction Synopsis END [ WORK | TRANSACTION ] Description 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 extension that is equivalent to COMMIT [commit(7)]. Parameters WORK TRANSACTION Optional…