📦 postgresql16

399 pages · page 1 of 2

A

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

B

BEGIN(7)start a transaction block✨
BEGIN(7pg16)start a transaction block✨

C

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

D

DEALLOCATE(7)deallocate a prepared statement✨
DEALLOCATE(7pg16)deallocate a prepared statement✨
DECLARE(7)define a cursor✨
DECLARE(7pg16)define a cursor✨