select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1
Historical version. PostgreSQL 7.1 reached end of support in April 2006. See the current version for supported releases.

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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.