Client Utility Summary

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.