Client Utility Summary
clusterdb
Reclusters tables that were previously clustered with CLUSTER.
clusterdb [connection-option ...] [-v] [-t table] [[-d] dbname] clusterdb [connection-option ...] [-a] [-v] clusterdb --help clusterdb --version
See clusterdb for more information.
createdb
Creates a new database.
createdb [connection_option ...] [-D tablespace] [-E encoding] [-O owner] [-T template] [-e] [dbname ['description']] createdb --help createdb --version
See createdb for more information.
createlang
Defines a new procedural language for a database.
createlang [connection_option ...] [-e] langname [[-d] dbname] createlang [connection-option ...] -l dbname createlang --help createlang --version
See createlang for more information.
createuser
Creates a new database role.
createuser [connection_option ...] [role_attribute ...] [-e] role_name createuser --help createuser --version
See createuser for more information.
dropdb
Removes a database.
dropdb [connection_option ...] [-e] [-i] dbname dropdb --help dropdb --version
See dropdb for more information.
droplang
Removes a procedural language.
droplang [connection-option ...] [-e] langname [[-d] dbname] droplang [connection-option ...] [-e] -l dbname droplang --help droplang --version
See droplang for more information.
dropuser
Removes a database role.
dropuser [connection_option ...] [-e] [-i] role_name dropuser --help dropuser --version
See dropuser for more information.
pg_config
Retrieves information about the installed version of Greenplum Database.
pg_config [option ...]
See pg_config for more information.
pg_dump
Extracts a database into a single script file or other archive file.
pg_dump [connection_option ...] [dump_option ...] dbname
See pg_dump for more information.
pg_dumpall
Extracts all databases in a Greenplum Database system to a single script file or other archive file.
pg_dumpall [connection_option ...] [dump_option ...]
See pg_dumpall for more information.
pg_restore
Restores a database from an archive file created by pg_dump.
pg_restore [connection_option ...] [restore_option ...] filename
See pg_restore for more information.
psql
Interactive command-line interface for Greenplum Database
psql [option ...] [dbname [username]]
See psql for more information.
reindexdb
Rebuilds indexes in a database.
reindexdb [connection-option ...] [--table | -t table ] [--index | -i index ] [dbname] reindexdb [connection-option ...] [--all | -a] reindexdb [connection-option ...] [--system | -s] [dbname] reindexdb --help reindexdb --version
See reindexdb for more information.
vacuumdb
Garbage-collects and analyzes a database.
vacuumdb [connection-option...] [--full | -f] [-F] [--verbose | -v] [--analyze | -z] [--table | -t table [( column [,...] )] ] [dbname] vacuumdb [connection-options...] [--all | -a] [--full | -f] [-F] [--verbose | -v] [--analyze | -z] vacuumdb --help vacuumdb --version
See vacuumdb for more information.