section 7pg15 · Miscellany 🌈

183 pages

A

ABORT(7pg15)abort the current transaction✨
ALTER_AGGREGATE(7pg15)change the definition of an aggregate function✨
ALTER_COLLATION(7pg15)change the definition of a collation✨
ALTER_CONVERSION(7pg15)change the definition of a conversion✨
ALTER_DATABASE(7pg15)change a database✨
ALTER_DEFAULT_PRIVILEGES(7pg15)define default access privileges✨
ALTER_DOMAIN(7pg15)change the definition of a domain✨
ALTER_EVENT_TRIGGER(7pg15)change the definition of an event trigger✨
ALTER_EXTENSION(7pg15)change the definition of an extension✨
ALTER_FOREIGN_DATA_WRAPPER(7pg15)change the definition of a foreign-data wrapper✨
ALTER_FOREIGN_TABLE(7pg15)change the definition of a foreign table✨
ALTER_FUNCTION(7pg15)change the definition of a function✨
ALTER_GROUP(7pg15)change role name or membership✨
ALTER_INDEX(7pg15)change the definition of an index✨
ALTER_LANGUAGE(7pg15)change the definition of a procedural language✨
ALTER_LARGE_OBJECT(7pg15)change the definition of a large object✨
ALTER_MATERIALIZED_VIEW(7pg15)change the definition of a materialized view✨
ALTER_OPERATOR(7pg15)change the definition of an operator✨
ALTER_OPERATOR_CLASS(7pg15)change the definition of an operator class✨
ALTER_OPERATOR_FAMILY(7pg15)change the definition of an operator family✨
ALTER_POLICY(7pg15)change the definition of a row-level security policy✨
ALTER_PROCEDURE(7pg15)change the definition of a procedure✨
ALTER_PUBLICATION(7pg15)change the definition of a publication✨
ALTER_ROLE(7pg15)change a database role✨
ALTER_ROUTINE(7pg15)change the definition of a routine✨
ALTER_RULE(7pg15)change the definition of a rule✨
ALTER_SCHEMA(7pg15)change the definition of a schema✨
ALTER_SEQUENCE(7pg15)change the definition of a sequence generator✨
ALTER_SERVER(7pg15)change the definition of a foreign server✨
ALTER_STATISTICS(7pg15)change the definition of an extended statistics object✨
ALTER_SUBSCRIPTION(7pg15)change the definition of a subscription✨
ALTER_SYSTEM(7pg15)change a server configuration parameter✨
ALTER_TABLE(7pg15)change the definition of a table✨
ALTER_TABLESPACE(7pg15)change the definition of a tablespace✨
ALTER_TEXT_SEARCH_CONFIGURATION(7pg15)change the definition of a text search configuration✨
ALTER_TEXT_SEARCH_DICTIONARY(7pg15)change the definition of a text search dictionary✨
ALTER_TEXT_SEARCH_PARSER(7pg15)change the definition of a text search parser✨
ALTER_TEXT_SEARCH_TEMPLATE(7pg15)change the definition of a text search template✨
ALTER_TRIGGER(7pg15)change the definition of a trigger✨
ALTER_TYPE(7pg15)change the definition of a type✨
ALTER_USER(7pg15)change a database role✨
ALTER_USER_MAPPING(7pg15)change the definition of a user mapping✨
ALTER_VIEW(7pg15)change the definition of a view✨
ANALYZE(7pg15)collect statistics about a database✨

B

BEGIN(7pg15)start a transaction block✨

C

CALL(7pg15)invoke a procedure✨
CHECKPOINT(7pg15)force a write-ahead log checkpoint✨
CLOSE(7pg15)close a cursor✨
CLUSTER(7pg15)cluster a table according to an index✨
COMMENT(7pg15)define or change the comment of an object✨
COMMIT(7pg15)commit the current transaction✨
COMMIT_PREPARED(7pg15)commit a transaction that was earlier prepared for two-phase commit✨
COPY(7pg15)copy data between a file and a table✨
CREATE_ACCESS_METHOD(7pg15)define a new access method✨
CREATE_AGGREGATE(7pg15)define a new aggregate function✨
CREATE_CAST(7pg15)define a new cast✨
CREATE_COLLATION(7pg15)define a new collation✨
CREATE_CONVERSION(7pg15)define a new encoding conversion✨
CREATE_DATABASE(7pg15)create a new database✨
CREATE_DOMAIN(7pg15)define a new domain✨
CREATE_EVENT_TRIGGER(7pg15)define a new event trigger✨
CREATE_EXTENSION(7pg15)install an extension✨
CREATE_FOREIGN_DATA_WRAPPER(7pg15)define a new foreign-data wrapper✨
CREATE_FOREIGN_TABLE(7pg15)define a new foreign table✨
CREATE_FUNCTION(7pg15)define a new function✨
CREATE_GROUP(7pg15)define a new database role✨
CREATE_INDEX(7pg15)define a new index✨
CREATE_LANGUAGE(7pg15)define a new procedural language✨
CREATE_MATERIALIZED_VIEW(7pg15)define a new materialized view✨
CREATE_OPERATOR(7pg15)define a new operator✨
CREATE_OPERATOR_CLASS(7pg15)define a new operator class✨
CREATE_OPERATOR_FAMILY(7pg15)define a new operator family✨
CREATE_POLICY(7pg15)define a new row-level security policy for a table✨
CREATE_PROCEDURE(7pg15)define a new procedure✨
CREATE_PUBLICATION(7pg15)define a new publication✨
CREATE_ROLE(7pg15)define a new database role✨
CREATE_RULE(7pg15)define a new rewrite rule✨
CREATE_SCHEMA(7pg15)define a new schema✨
CREATE_SEQUENCE(7pg15)define a new sequence generator✨
CREATE_SERVER(7pg15)define a new foreign server✨
CREATE_STATISTICS(7pg15)define extended statistics✨
CREATE_SUBSCRIPTION(7pg15)define a new subscription✨
CREATE_TABLE(7pg15)define a new table✨
CREATE_TABLE_AS(7pg15)define a new table from the results of a query✨
CREATE_TABLESPACE(7pg15)define a new tablespace✨
CREATE_TEXT_SEARCH_CONFIGURATION(7pg15)define a new text search configuration✨
CREATE_TEXT_SEARCH_DICTIONARY(7pg15)define a new text search dictionary✨
CREATE_TEXT_SEARCH_PARSER(7pg15)define a new text search parser✨
CREATE_TEXT_SEARCH_TEMPLATE(7pg15)define a new text search template✨
CREATE_TRANSFORM(7pg15)define a new transform✨
CREATE_TRIGGER(7pg15)define a new trigger✨
CREATE_TYPE(7pg15)define a new data type✨
CREATE_USER(7pg15)define a new database role✨
CREATE_USER_MAPPING(7pg15)define a new mapping of a user to a foreign server✨
CREATE_VIEW(7pg15)define a new view✨

D

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

E

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

F

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

G

GRANT(7pg15)define access privileges✨

I

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

L

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

M

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

N

NOTIFY(7pg15)generate a notification✨

P

PREPARE(7pg15)prepare a statement for execution✨
PREPARE_TRANSACTION(7pg15)prepare the current transaction for two-phase commit✨

R

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

S

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

T

TRUNCATE(7pg15)empty a table or set of tables✨

U

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

V

VACUUM(7pg15)garbage-collect and optionally analyze a database✨
VALUES(7pg15)compute a set of rows✨