PostgreSQL 7.2.1 Documentation
PrevNext

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 may 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
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
pgaccess -- a graphical PostgreSQL client application
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 all PostgreSQL databases into a script file
pg_restore --  restore a PostgreSQL database from an archive file created by pg_dump
psql --  PostgreSQL interactive terminal
pgtclsh --  PostgreSQL Tcl shell client
pgtksh --  PostgreSQL Tcl/Tk shell client
vacuumdb -- garbage-collect and analyze a PostgreSQL database
PrevHomeNext
VACUUMUpcreatedb