II. PostgreSQL Client Applications
This is reference information for Postgres client applications and
utilities.
- Table of Contents
- createdb -- Create a new
Postgres database
- createuser -- Create a
new Postgres user
- dropdb -- Remove an
existing Postgres
database
- dropuser -- Drops
(removes) a Postgres
user
- ecpg -- Embedded SQL C
preprocessor
- pgaccess -- PostgreSQL graphical client
- pgadmin -- Postgres database management and
design tool for Windows 95/98/NT
- pg_config -- Provides
information about the installed version of PostgreSQL
- pg_dump --
Extract a Postgres
database into a script file or other archive file
- pg_dumpall -- Extract
all databases into a script file
- pg_restore -- Restore a
Postgres database from an
archive file created by pg_dump
- psql -- Postgres interactive terminal
- pgtclsh --
PostgreSQL Tcl shell client
- pgtksh --
PostgreSQL Tcl/Tk shell client
- vacuumdb -- Clean and
analyze a Postgres
database
