📦 postgresql18

400 pages · page 2 of 2

D (continued)

DELETE(7)delete rows of a table✨
DELETE(7pg18)delete rows of a table✨
DISCARD(7)discard session state✨
DISCARD(7pg18)discard session state✨
DO(7)execute an anonymous code block✨
DO(7pg18)execute an anonymous code block✨
DROP_ACCESS_METHOD(7)remove an access method✨
DROP_ACCESS_METHOD(7pg18)remove an access method✨
DROP_AGGREGATE(7)remove an aggregate function✨
DROP_AGGREGATE(7pg18)remove an aggregate function✨
DROP_CAST(7)remove a cast✨
DROP_CAST(7pg18)remove a cast✨
DROP_COLLATION(7)remove a collation✨
DROP_COLLATION(7pg18)remove a collation✨
DROP_CONVERSION(7)remove a conversion✨
DROP_CONVERSION(7pg18)remove a conversion✨
DROP_DATABASE(7)remove a database✨
DROP_DATABASE(7pg18)remove a database✨
DROP_DOMAIN(7)remove a domain✨
DROP_DOMAIN(7pg18)remove a domain✨
DROP_EVENT_TRIGGER(7)remove an event trigger✨
DROP_EVENT_TRIGGER(7pg18)remove an event trigger✨
DROP_EXTENSION(7)remove an extension✨
DROP_EXTENSION(7pg18)remove an extension✨
DROP_FOREIGN_DATA_WRAPPER(7)remove a foreign-data wrapper✨
DROP_FOREIGN_DATA_WRAPPER(7pg18)remove a foreign-data wrapper✨
DROP_FOREIGN_TABLE(7)remove a foreign table✨
DROP_FOREIGN_TABLE(7pg18)remove a foreign table✨
DROP_FUNCTION(7)remove a function✨
DROP_FUNCTION(7pg18)remove a function✨
DROP_GROUP(7)remove a database role✨
DROP_GROUP(7pg18)remove a database role✨
DROP_INDEX(7)remove an index✨
DROP_INDEX(7pg18)remove an index✨
DROP_LANGUAGE(7)remove a procedural language✨
DROP_LANGUAGE(7pg18)remove a procedural language✨
DROP_MATERIALIZED_VIEW(7)remove a materialized view✨
DROP_MATERIALIZED_VIEW(7pg18)remove a materialized view✨
DROP_OPERATOR(7)remove an operator✨
DROP_OPERATOR(7pg18)remove an operator✨
DROP_OPERATOR_CLASS(7)remove an operator class✨
DROP_OPERATOR_CLASS(7pg18)remove an operator class✨
DROP_OPERATOR_FAMILY(7)remove an operator family✨
DROP_OPERATOR_FAMILY(7pg18)remove an operator family✨
DROP_OWNED(7)remove database objects owned by a database role✨
DROP_OWNED(7pg18)remove database objects owned by a database role✨
DROP_POLICY(7)remove a row-level security policy from a table✨
DROP_POLICY(7pg18)remove a row-level security policy from a table✨
DROP_PROCEDURE(7)remove a procedure✨
DROP_PROCEDURE(7pg18)remove a procedure✨
DROP_PUBLICATION(7)remove a publication✨
DROP_PUBLICATION(7pg18)remove a publication✨
DROP_ROLE(7)remove a database role✨
DROP_ROLE(7pg18)remove a database role✨
DROP_ROUTINE(7)remove a routine✨
DROP_ROUTINE(7pg18)remove a routine✨
DROP_RULE(7)remove a rewrite rule✨
DROP_RULE(7pg18)remove a rewrite rule✨
DROP_SCHEMA(7)remove a schema✨
DROP_SCHEMA(7pg18)remove a schema✨
DROP_SEQUENCE(7)remove a sequence✨
DROP_SEQUENCE(7pg18)remove a sequence✨
DROP_SERVER(7)remove a foreign server descriptor✨
DROP_SERVER(7pg18)remove a foreign server descriptor✨
DROP_STATISTICS(7)remove extended statistics✨
DROP_STATISTICS(7pg18)remove extended statistics✨
DROP_SUBSCRIPTION(7)remove a subscription✨
DROP_SUBSCRIPTION(7pg18)remove a subscription✨
DROP_TABLE(7)remove a table✨
DROP_TABLE(7pg18)remove a table✨
DROP_TABLESPACE(7)remove a tablespace✨
DROP_TABLESPACE(7pg18)remove a tablespace✨
DROP_TEXT_SEARCH_CONFIGURATION(7)remove a text search configuration✨
DROP_TEXT_SEARCH_CONFIGURATION(7pg18)remove a text search configuration✨
DROP_TEXT_SEARCH_DICTIONARY(7)remove a text search dictionary✨
DROP_TEXT_SEARCH_DICTIONARY(7pg18)remove a text search dictionary✨
DROP_TEXT_SEARCH_PARSER(7)remove a text search parser✨
DROP_TEXT_SEARCH_PARSER(7pg18)remove a text search parser✨
DROP_TEXT_SEARCH_TEMPLATE(7)remove a text search template✨
DROP_TEXT_SEARCH_TEMPLATE(7pg18)remove a text search template✨
DROP_TRANSFORM(7)remove a transform✨
DROP_TRANSFORM(7pg18)remove a transform✨
DROP_TRIGGER(7)remove a trigger✨
DROP_TRIGGER(7pg18)remove a trigger✨
DROP_TYPE(7)remove a data type✨
DROP_TYPE(7pg18)remove a data type✨
DROP_USER(7)remove a database role✨
DROP_USER(7pg18)remove a database role✨
DROP_USER_MAPPING(7)remove a user mapping for a foreign server✨
DROP_USER_MAPPING(7pg18)remove a user mapping for a foreign server✨
DROP_VIEW(7)remove a view✨
DROP_VIEW(7pg18)remove a view✨
dropdb(1)remove a PostgreSQL database✨
dropdb(1pg18)remove a PostgreSQL database✨
dropuser(1)remove a PostgreSQL user account✨
dropuser(1pg18)remove a PostgreSQL user account✨

E

END(7)commit the current transaction✨
END(7pg18)commit the current transaction✨
EXECUTE(7)execute a prepared statement✨
EXECUTE(7pg18)execute a prepared statement✨
EXPLAIN(7)show the execution plan of a statement✨
EXPLAIN(7pg18)show the execution plan of a statement✨

F

FETCH(7)retrieve rows from a query using a cursor✨
FETCH(7pg18)retrieve rows from a query using a cursor✨

G

GRANT(7)define access privileges✨
GRANT(7pg18)define access privileges✨

I

IMPORT_FOREIGN_SCHEMA(7)import table definitions from a foreign server✨
IMPORT_FOREIGN_SCHEMA(7pg18)import table definitions from a foreign server✨
INSERT(7)create new rows in a table✨
INSERT(7pg18)create new rows in a table✨

L

LISTEN(7)listen for a notification✨
LISTEN(7pg18)listen for a notification✨
LOAD(7)load a shared library file✨
LOAD(7pg18)load a shared library file✨
LOCK(7)lock a table✨
LOCK(7pg18)lock a table✨

M

MERGE(7)conditionally insert, update, or delete rows of a table✨
MERGE(7pg18)conditionally insert, update, or delete rows of a table✨
MOVE(7)position a cursor✨
MOVE(7pg18)position a cursor✨

N

NOTIFY(7)generate a notification✨
NOTIFY(7pg18)generate a notification✨

P

pg_basebackup(1pg18)take a base backup of a PostgreSQL cluster✨
pg_checksums(1pg18)enable, disable or check data checksums in a PostgreSQL database cluster✨
pg_combinebackup(1pg18)reconstruct a full backup from an incremental backup and dependent backups✨
pg_dump(1)export a PostgreSQL database as an SQL script or to other formats✨
pg_dump(1pg18)export a PostgreSQL database as an SQL script or to other formats✨
pg_dumpall(1)extract a PostgreSQL database cluster into a script file✨
pg_dumpall(1pg18)extract a PostgreSQL database cluster into a script file✨
pg_isready(1)check the connection status of a PostgreSQL server✨
pg_isready(1pg18)check the connection status of a PostgreSQL server✨
pg_receivewal(1pg18)stream write-ahead logs from a PostgreSQL server✨
pg_recvlogical(1pg18)control PostgreSQL logical decoding streams✨
pg_restore(1)restore a PostgreSQL database from an archive file created by pg_dump✨
pg_restore(1pg18)restore a PostgreSQL database from an archive file created by pg_dump✨
pg_rewind(1pg18)synchronize a PostgreSQL data directory with another data directory that was forked from it✨
pg_upgrade(1)upgrade a PostgreSQL server instance✨
pg_verifybackup(1pg18)verify the integrity of a base backup of a PostgreSQL cluster✨
PREPARE(7)prepare a statement for execution✨
PREPARE(7pg18)prepare a statement for execution✨
PREPARE_TRANSACTION(7)prepare the current transaction for two-phase commit✨
PREPARE_TRANSACTION(7pg18)prepare the current transaction for two-phase commit✨
psql(1)PostgreSQL interactive terminal✨
psql(1pg18)PostgreSQL interactive terminal✨

R

REASSIGN_OWNED(7)change the ownership of database objects owned by a database role✨
REASSIGN_OWNED(7pg18)change the ownership of database objects owned by a database role✨
REFRESH_MATERIALIZED_VIEW(7)replace the contents of a materialized view✨
REFRESH_MATERIALIZED_VIEW(7pg18)replace the contents of a materialized view✨
REINDEX(7)rebuild indexes✨
REINDEX(7pg18)rebuild indexes✨
reindexdb(1)reindex a PostgreSQL database✨
reindexdb(1pg18)reindex a PostgreSQL database✨
RELEASE_SAVEPOINT(7)release a previously defined savepoint✨
RELEASE_SAVEPOINT(7pg18)release a previously defined savepoint✨
RESET(7)restore the value of a run-time parameter to the default value✨
RESET(7pg18)restore the value of a run-time parameter to the default value✨
REVOKE(7)remove access privileges✨
REVOKE(7pg18)remove access privileges✨
ROLLBACK(7)abort the current transaction✨
ROLLBACK(7pg18)abort the current transaction✨
ROLLBACK_PREPARED(7)cancel a transaction that was earlier prepared for two-phase commit✨
ROLLBACK_PREPARED(7pg18)cancel a transaction that was earlier prepared for two-phase commit✨
ROLLBACK_TO_SAVEPOINT(7)roll back to a savepoint✨
ROLLBACK_TO_SAVEPOINT(7pg18)roll back to a savepoint✨

S

SAVEPOINT(7)define a new savepoint within the current transaction✨
SAVEPOINT(7pg18)define a new savepoint within the current transaction✨
SECURITY_LABEL(7)define or change a security label applied to an object✨
SECURITY_LABEL(7pg18)define or change a security label applied to an object✨
SELECT(7)retrieve rows from a table or view✨
SELECT(7pg18)retrieve rows from a table or view✨
SELECT_INTO(7)define a new table from the results of a query✨
SELECT_INTO(7pg18)define a new table from the results of a query✨
SET(7)change a run-time parameter✨
SET(7pg18)change a run-time parameter✨
SET_CONSTRAINTS(7)set constraint check timing for the current transaction✨
SET_CONSTRAINTS(7pg18)set constraint check timing for the current transaction✨
SET_ROLE(7)set the current user identifier of the current session✨
SET_ROLE(7pg18)set the current user identifier of the current session✨
SET_SESSION_AUTHORIZATION(7)set the session user identifier and the current user identifier of the current session✨
SET_SESSION_AUTHORIZATION(7pg18)set the session user identifier and the current user identifier of the current session✨
SET_TRANSACTION(7)set the characteristics of the current transaction✨
SET_TRANSACTION(7pg18)set the characteristics of the current transaction✨
SHOW(7)show the value of a run-time parameter✨
SHOW(7pg18)show the value of a run-time parameter✨
START_TRANSACTION(7)start a transaction block✨
START_TRANSACTION(7pg18)start a transaction block✨

T

TABLE(7)retrieve rows from a table or view✨
TRUNCATE(7)empty a table or set of tables✨
TRUNCATE(7pg18)empty a table or set of tables✨

U

UNLISTEN(7)stop listening for a notification✨
UNLISTEN(7pg18)stop listening for a notification✨
UPDATE(7)update rows of a table✨
UPDATE(7pg18)update rows of a table✨

V

VACUUM(7)garbage-collect and optionally analyze a database✨
VACUUM(7pg18)garbage-collect and optionally analyze a database✨
vacuumdb(1)garbage-collect and analyze a PostgreSQL database✨
vacuumdb(1pg18)garbage-collect and analyze a PostgreSQL database✨
VALUES(7)compute a set of rows✨
VALUES(7pg18)compute a set of rows✨

W

WITH(7)retrieve rows from a table or view✨