Man Pages in
postgresql-client-9.4
Carta.tech
Packages
postgresql-client-9.4
17
Section 1:
Executable programs or shell commands
clusterdb.1
Cluster a postgresql database
createdb.1
Create a new postgresql database
createlang.1
Install a postgresql procedural language
createuser.1
Define a new postgresql user account
dropdb.1
Remove a postgresql database
droplang.1
Remove a postgresql procedural language
dropuser.1
Remove a postgresql user account
pg_basebackup.1
Take a base backup of a postgresql cluster
pg_dump.1
Extract a postgresql database into a script file or other archive file
pg_dumpall.1
Extract a postgresql database cluster into a script file
pg_isready.1
Check the connection status of a postgresql server
pg_receivexlog.1
Stream transaction logs from a postgresql server
pg_recvlogical.1
Control postgresql logical decoding streams
pg_restore.1
Restore a postgresql database from an archive file created by pg_dump
psql.1
Postgresql interactive terminal
reindexdb.1
Reindex a postgresql database
vacuumdb.1
Garbage-collect and analyze a postgresql database
157
Section 7:
Miscellaneous
ABORT.7
Abort the current transaction
ALTER_AGGREGATE.7
Change the definition of an aggregate function
ALTER_COLLATION.7
Change the definition of a collation
ALTER_CONVERSION.7
Change the definition of a conversion
ALTER_DATABASE.7
Change a database
ALTER_DEFAULT_PRIVILEGES.7
Define default access privileges
ALTER_DOMAIN.7
Change the definition of a domain
ALTER_EVENT_TRIGGER.7
Change the definition of an event trigger
ALTER_EXTENSION.7
Change the definition of an extension
ALTER_FOREIGN_DATA_WRAPPER.7
Change the definition of a foreign-data wrapper
ALTER_FOREIGN_TABLE.7
Change the definition of a foreign table
ALTER_FUNCTION.7
Change the definition of a function
ALTER_GROUP.7
Change role name or membership
ALTER_INDEX.7
Change the definition of an index
ALTER_LANGUAGE.7
Change the definition of a procedural language
ALTER_LARGE_OBJECT.7
Change the definition of a large object
ALTER_MATERIALIZED_VIEW.7
Change the definition of a materialized view
ALTER_OPERATOR.7
Change the definition of an operator
ALTER_OPERATOR_CLASS.7
Change the definition of an operator class
ALTER_OPERATOR_FAMILY.7
Change the definition of an operator family
ALTER_ROLE.7
Change a database role
ALTER_RULE.7
Change the definition of a rule
ALTER_SCHEMA.7
Change the definition of a schema
ALTER_SEQUENCE.7
Change the definition of a sequence generator
ALTER_SERVER.7
Change the definition of a foreign server
ALTER_SYSTEM.7
Change a server configuration parameter
ALTER_TABLE.7
Change the definition of a table
ALTER_TABLESPACE.7
Change the definition of a tablespace
ALTER_TEXT_SEARCH_CONFIGURATION.7
Change the definition of a text search configuration
ALTER_TEXT_SEARCH_DICTIONARY.7
Change the definition of a text search dictionary
ALTER_TEXT_SEARCH_PARSER.7
Change the definition of a text search parser
ALTER_TEXT_SEARCH_TEMPLATE.7
Change the definition of a text search template
ALTER_TRIGGER.7
Change the definition of a trigger
ALTER_TYPE.7
Change the definition of a type
ALTER_USER.7
Change a database role
ALTER_USER_MAPPING.7
Change the definition of a user mapping
ALTER_VIEW.7
Change the definition of a view
ANALYZE.7
Collect statistics about a database
BEGIN.7
Start a transaction block
CHECKPOINT.7
Force a transaction log checkpoint
CLOSE.7
Close a cursor
CLUSTER.7
Cluster a table according to an index
COMMENT.7
Define or change the comment of an object
COMMIT.7
Commit the current transaction
COMMIT_PREPARED.7
Commit a transaction that was earlier prepared for two-phase commit
CREATE_AGGREGATE.7
Define a new aggregate function
CREATE_CAST.7
Define a new cast
CREATE_COLLATION.7
Define a new collation
CREATE_CONVERSION.7
Define a new encoding conversion
CREATE_DATABASE.7
Create a new database
CREATE_DOMAIN.7
Define a new domain
CREATE_EVENT_TRIGGER.7
Define a new event trigger
CREATE_EXTENSION.7
Install an extension
CREATE_FOREIGN_DATA_WRAPPER.7
Define a new foreign-data wrapper
CREATE_FOREIGN_TABLE.7
Define a new foreign table
CREATE_FUNCTION.7
Define a new function
CREATE_GROUP.7
Define a new database role
CREATE_INDEX.7
Define a new index
CREATE_LANGUAGE.7
Define a new procedural language
CREATE_MATERIALIZED_VIEW.7
Define a new materialized view
CREATE_OPERATOR.7
Define a new operator
CREATE_OPERATOR_CLASS.7
Define a new operator class
CREATE_OPERATOR_FAMILY.7
Define a new operator family
CREATE_ROLE.7
Define a new database role
CREATE_RULE.7
Define a new rewrite rule
CREATE_SCHEMA.7
Define a new schema
CREATE_SEQUENCE.7
Define a new sequence generator
CREATE_SERVER.7
Define a new foreign server
CREATE_TABLE.7
Define a new table
CREATE_TABLESPACE.7
Define a new tablespace
CREATE_TABLE_AS.7
Define a new table from the results of a query
CREATE_TEXT_SEARCH_CONFIGURATION.7
Define a new text search configuration
CREATE_TEXT_SEARCH_DICTIONARY.7
Define a new text search dictionary
CREATE_TEXT_SEARCH_PARSER.7
Define a new text search parser
CREATE_TEXT_SEARCH_TEMPLATE.7
Define a new text search template
CREATE_TYPE.7
Define a new data type
CREATE_USER.7
Define a new database role
CREATE_USER_MAPPING.7
Define a new mapping of a user to a foreign server
CREATE_VIEW.7
Define a new view
DEALLOCATE.7
Deallocate a prepared statement
DECLARE.7
Define a cursor
DELETE.7
Delete rows of a table
DISCARD.7
Discard session state
DO.7
Execute an anonymous code block
DROP_AGGREGATE.7
Remove an aggregate function
DROP_CAST.7
Remove a cast
DROP_COLLATION.7
Remove a collation
DROP_CONVERSION.7
Remove a conversion
DROP_DATABASE.7
Remove a database
DROP_DOMAIN.7
Remove a domain
DROP_EVENT_TRIGGER.7
Remove an event trigger
DROP_EXTENSION.7
Remove an extension
DROP_FOREIGN_DATA_WRAPPER.7
Remove a foreign-data wrapper
DROP_FOREIGN_TABLE.7
Remove a foreign table
DROP_FUNCTION.7
Remove a function
DROP_GROUP.7
Remove a database role
DROP_INDEX.7
Remove an index
DROP_LANGUAGE.7
Remove a procedural language
DROP_MATERIALIZED_VIEW.7
Remove a materialized view
DROP_OPERATOR.7
Remove an operator
DROP_OPERATOR_CLASS.7
Remove an operator class
DROP_OPERATOR_FAMILY.7
Remove an operator family
DROP_OWNED.7
Remove database objects owned by a database role
DROP_ROLE.7
Remove a database role
DROP_RULE.7
Remove a rewrite rule
DROP_SCHEMA.7
Remove a schema
DROP_SEQUENCE.7
Remove a sequence
DROP_SERVER.7
Remove a foreign server descriptor
DROP_TABLE.7
Remove a table
DROP_TABLESPACE.7
Remove a tablespace
DROP_TEXT_SEARCH_CONFIGURATION.7
Remove a text search configuration
DROP_TEXT_SEARCH_DICTIONARY.7
Remove a text search dictionary
DROP_TEXT_SEARCH_PARSER.7
Remove a text search parser
DROP_TEXT_SEARCH_TEMPLATE.7
Remove a text search template
DROP_TRIGGER.7
Remove a trigger
DROP_TYPE.7
Remove a data type
DROP_USER.7
Remove a database role
DROP_USER_MAPPING.7
Remove a user mapping for a foreign server
DROP_VIEW.7
Remove a view
END.7
Commit the current transaction
EXECUTE.7
Execute a prepared statement
EXPLAIN.7
Show the execution plan of a statement
FETCH.7
Retrieve rows from a query using a cursor
GRANT.7
Define access privileges
INSERT.7
Create new rows in a table
LISTEN.7
Listen for a notification
LOAD.7
Load a shared library file
LOCK.7
Lock a table
MOVE.7
Position a cursor
NOTIFY.7
Generate a notification
PREPARE.7
Prepare a statement for execution
PREPARE_TRANSACTION.7
Prepare the current transaction for two-phase commit
REASSIGN_OWNED.7
Change the ownership of database objects owned by a database role
REFRESH_MATERIALIZED_VIEW.7
Replace the contents of a materialized view
REINDEX.7
Rebuild indexes
RELEASE_SAVEPOINT.7
Destroy a previously defined savepoint
RESET.7
Restore the value of a run-time parameter to the default value
REVOKE.7
Remove access privileges
ROLLBACK.7
Abort the current transaction
ROLLBACK_PREPARED.7
Cancel a transaction that was earlier prepared for two-phase commit
ROLLBACK_TO_SAVEPOINT.7
Roll back to a savepoint
SAVEPOINT.7
Define a new savepoint within the current transaction
SECURITY_LABEL.7
Define or change a security label applied to an object
SELECT.7
Retrieve rows from a table or view
SELECT_INTO.7
Define a new table from the results of a query
SET.7
Change a run-time parameter
SET_CONSTRAINTS.7
Set constraint check timing for the current transaction
SET_ROLE.7
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_TRANSACTION.7
Set the characteristics of the current transaction
SHOW.7
Show the value of a run-time parameter
START_TRANSACTION.7
Start a transaction block
TRUNCATE.7
Empty a table or set of tables
UNLISTEN.7
Stop listening for a notification
UPDATE.7
Update rows of a table
VACUUM.7
Garbage-collect and optionally analyze a database
VALUES.7
Compute a set of rows