II. 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.
- Table of Contents
- clusterdb -- cluster a
PostgreSQL database
- createdb -- create a new
PostgreSQL database
- createlang -- install a
PostgreSQL procedural
language
- createuser -- define a
new PostgreSQL user
account
- dropdb -- remove a
PostgreSQL database
- droplang -- remove a
PostgreSQL procedural
language
- dropuser -- remove a
PostgreSQL user
account
- ecpg -- embedded SQL C
preprocessor
- pg_basebackup -- take
a base backup of a PostgreSQL cluster
- 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_restore -- restore a
PostgreSQL database from
an archive file created by pg_dump
- psql -- PostgreSQL interactive terminal
- reindexdb -- reindex a
PostgreSQL database
- vacuumdb -- garbage-collect
and analyze a PostgreSQL
database