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