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 -- define a new 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_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