PostgreSQL Client Applications
This part contains reference information for
PostgreSQL client applications and
utilities. Not all of these commands are of general utility; some
might require special privileges. The common feature of these
applications is that they can be run on any host, independent of
where the database server resides.
When specified on the command line, user and database names have
their case preserved — the presence of spaces or special
characters might require quoting. Table names and other identifiers
do not have their case preserved, except where documented, and
might require quoting.
Table of Contents
- clusterdb — cluster a PostgreSQL database
- createdb — create a new PostgreSQL database
- createuser — define a new PostgreSQL user account
- dropdb — remove a PostgreSQL database
- dropuser — remove a PostgreSQL user account
- ecpg — embedded SQL C preprocessor
- pg_amcheck — checks for corruption in one or more
PostgreSQL databases
- pg_basebackup — take a base backup of a PostgreSQL cluster
- pgbench — run a benchmark test on PostgreSQL
- pg_combinebackup — reconstruct a full backup from an incremental backup and dependent backups
- pg_config — retrieve information about the installed version of PostgreSQL
- pg_dump —
extract a PostgreSQL database into a script file or other archive file
- pg_dumpall — extract a PostgreSQL database cluster into a script file
- pg_isready — check the connection status of a PostgreSQL server
- pg_receivewal — stream write-ahead logs from a PostgreSQL server
- pg_recvlogical — control PostgreSQL logical decoding streams
- pg_restore —
restore a PostgreSQL database from an
archive file created by pg_dump
- pg_verifybackup — verify the integrity of a base backup of a
PostgreSQL cluster
- psql —
PostgreSQL interactive terminal
- reindexdb — reindex a PostgreSQL database
- vacuumdb — garbage-collect and analyze a PostgreSQL database