Creates a new database.
Synopsis
createdb [<connection-option> ...] [<option> ...] [<dbname> ['<description>']]
createdb -? | --help
createdb -V | --version
Description
createdb
creates a new database in a Greenplum Database system.
Normally, the database user who runs this command becomes the owner of the new database. However, a different owner can be specified via the -O
option, if the executing user has appropriate privileges.
createdb
is a wrapper around the SQL command CREATE DATABASE .
Options
- dbname
- The name of the database to be created. The name must be unique among all other databases in the Greenplum system. If not specified, reads from the environment variable
PGDATABASE
, thenPGUSER
or defaults to the current system user. - description
- A comment to be associated with the newly created database. Descriptions containing white space must be enclosed in quotes.
- -D tablespace | --tablespace=tablespace
- Specifies the default tablespace for the database. (This name is processed as a double-quoted identifier.)
- -e echo
- Echo the commands that
createdb
generates and sends to the server. - -E encoding | --encoding encoding
- Character set encoding to use in the new database. Specify a string constant (such as
'UTF8'
), an integer encoding number, orDEFAULT
to use the default encoding. See the Greenplum Database Reference Guide for information about supported character sets. - -l locale | --locale locale
- Specifies the locale to be used in this database. This is equivalent to specifying both
--lc-collate
and--lc-ctype
. - --lc-collate locale
- Specifies the
LC_COLLATE
setting to be used in this database. - --lc-ctype locale
- Specifies the
LC_CTYPE
setting to be used in this database. - -O owner | --owner=owner
- The name of the database user who will own the new database. Defaults to the user running this command. (This name is processed as a double-quoted identifier.)
- -T template | --template=template
- The name of the template from which to create the new database. Defaults to
template1
. (This name is processed as a double-quoted identifier.) - -V | --version
- Print the
createdb
version and exit. - -? | --help
- Show help about
createdb
command line arguments, and exit.
The options -D
, -l
, -E
, -O
, and -T
correspond to options of the underlying SQL command CREATE DATABASE
; see CREATE DATABASE in the Greenplum Database Reference Guide for more information about them.
Connection Options
- -h host | --host=host
- The host name of the machine on which the Greenplum master database server is running. If not specified, reads from the environment variable
PGHOST
or defaults to localhost. - -p port | --port=port
- The TCP port on which the Greenplum master database server is listening for connections. If not specified, reads from the environment variable
PGPORT
or defaults to 5432. - -U username | --username=username
- The database role name to connect as. If not specified, reads from the environment variable
PGUSER
or defaults to the current system role name. - -w | --no-password
- Never issue a password prompt. If the server requires password authentication and a password is not available by other means such as a
.pgpass
file, the connection attempt will fail. This option can be useful in batch jobs and scripts where no user is present to enter a password. - -W | --password
- Force a password prompt.
- --maintenance-db=dbname
- Specifies the name of the database to connect to when creating the new database. If not specified, the
postgres
database will be used; if that does not exist (or if it is the name of the new database being created),template1
will be used.
Examples
To create the database test
using the default options:
createdb test
To create the database demo
using the Greenplum master on host gpmaster
, port 54321
, using the LATIN1
encoding scheme:
createdb -p 54321 -h gpmaster -E LATIN1 demo
Content feedback and comments