Client Utility Summary

Client Utility Summary

clusterdb

Reclusters tables that were previously clustered with CLUSTER.

clusterdb [connection-option ...] [--verbose | -v] [--table | -t table] [[--dbname | -d] dbname]

clusterdb [connection-option ...] [--all | -a] [--verbose | -v]

clusterdb -? | --help

clusterdb -V | --version

See clusterdb for more information.

createdb

Creates a new database.

createdb [connection-option ...] [option ...] [dbname ['description']]

createdb -? | --help

createdb -V | --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 -V | --version

See createlang for more information.

createuser

Creates a new database role.

createuser [connection-option ...] [role_attribute ...] [-e] role_name

createuser -? | --help 

createuser -V | --version

See createuser for more information.

dropdb

Removes a database.

dropdb [connection-option ...] [-e] [-i] dbname

dropdb -? | --help

dropdb -V | --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 -V | --version

See droplang for more information.

dropuser

Removes a database role.

dropuser [connection-option ...] [-e] [-i] role_name

dropuser -? | --help 

dropuser -V | --version

See dropuser for more information.

pg_config

Retrieves information about the installed version of Greenplum Database.

pg_config [option ...]

pg_config -? | --help

pg_config --version

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]

pg_dump -? | --help

pg_dump -V | --version

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 ...]

pg_dumpall -? | --help

pg_dumpall -V | --version

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

pg_restore -? | --help

pg_restore -V | --version

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 -V | --version

See reindexdb for more information.

vacuumdb

Garbage-collects and analyzes a database.

vacuumdb [connection-option...] [--full | -f] [--freeze | -F] [--verbose | -v]
    [--analyze | -z] [--analyze-only | -Z] [--table | -t table [( column [,...] )] ] [dbname]

vacuumdb [connection-option...] [--all | -a] [--full | -f] [-F] 
    [--verbose | -v] [--analyze | -z]
    [--analyze-only | -Z]

vacuumdb -? | --help

vacuumdb -V | --version

See vacuumdb for more information.