createdb

environment

map[description:If set, the name of the database to create, unless overridden on the command line. name:PGDATABASE], map[description:Default connection parameters. PGUSER also determines the name of the database to create, if it is not specified on the command line or by PGDATABASE . name:PGHOST PGPORT PGUSER], map[description:Specifies whether to use color in diagnostic messages. Possible values are always , auto and never . name:PG_COLOR]

options

map[description:Specifies the default tablespace for the database. (This name is processed as a double-quoted identifier.) names:[-D tablespace --tablespace= tablespace] signature:-D tablespace --tablespace= tablespace source_url:/docs/18/app-createdb.html summary:Specifies the default tablespace for the database. (This name is processed as a double-quoted identifier.)], map[description:Echo the commands that createdb generates and sends to the server. names:[-e --echo] signature:-e --echo source_url:/docs/18/app-createdb.html summary:Echo the commands that createdb generates and sends to the server.], map[description:Specifies the character encoding scheme to be used in this database. The character sets supported by the PostgreSQL server are described in Section 23.3.1 . names:[-E encoding --encoding= encoding] signature:-E encoding --encoding= encoding source_url:/docs/18/app-createdb.html summary:Specifies the character encoding scheme to be used in this database. The character sets supported by the PostgreSQL server are described in Section 23.3.1 .], map[description:Specifies the locale to be used in this database. This is equivalent to specifying --lc-collate , --lc-ctype , and --icu-locale to the same value. Some locales are only valid for ICU and must be set with --icu-locale . names:[-l locale --locale= locale] signature:-l locale --locale= locale source_url:/docs/18/app-createdb.html summary:Specifies the locale to be used in this database. This is equivalent to specifying --lc-collate , --lc-ctype , and --icu-locale to the same value. Some locales are only valid for ICU and must be set with --icu-locale .], map[description:Specifies the LC_COLLATE setting to be used in this database. names:[--lc-collate= locale] signature:--lc-collate= locale source_url:/docs/18/app-createdb.html summary:Specifies the LC_COLLATE setting to be used in this database.], map[description:Specifies the LC_CTYPE setting to be used in this database. names:[--lc-ctype= locale] signature:--lc-ctype= locale source_url:/docs/18/app-createdb.html summary:Specifies the LC_CTYPE setting to be used in this database.], map[description:Specifies the locale name when the builtin provider is used. Locale support is described in Section 23.1 . names:[--builtin-locale= locale] signature:--builtin-locale= locale source_url:/docs/18/app-createdb.html summary:Specifies the locale name when the builtin provider is used. Locale support is described in Section 23.1 .], map[description:Specifies the ICU locale ID to be used in this database, if the ICU locale provider is selected. names:[--icu-locale= locale] signature:--icu-locale= locale source_url:/docs/18/app-createdb.html summary:Specifies the ICU locale ID to be used in this database, if the ICU locale provider is selected.], map[description:Specifies additional collation rules to customize the behavior of the default collation of this database. This is supported for ICU only. names:[--icu-rules= rules] signature:--icu-rules= rules source_url:/docs/18/app-createdb.html summary:Specifies additional collation rules to customize the behavior of the default collation of this database. This is supported for ICU only.], map[description:Specifies the locale provider for the database's default collation. names:[--locale-provider={ builtin | libc | icu }] signature:--locale-provider={ builtin | libc | icu } source_url:/docs/18/app-createdb.html summary:Specifies the locale provider for the database's default collation.], map[description:Specifies the database user who will own the new database. (This name is processed as a double-quoted identifier.) names:[-O owner --owner= owner] signature:-O owner --owner= owner source_url:/docs/18/app-createdb.html summary:Specifies the database user who will own the new database. (This name is processed as a double-quoted identifier.)], map[description:Specifies the database creation strategy. See CREATE DATABASE STRATEGY for more details. names:[-S strategy --strategy= strategy] signature:-S strategy --strategy= strategy source_url:/docs/18/app-createdb.html summary:Specifies the database creation strategy. See CREATE DATABASE STRATEGY for more details.], map[description:Specifies the template database from which to build this database. (This name is processed as a double-quoted identifier.) names:[-T template --template= template] signature:-T template --template= template source_url:/docs/18/app-createdb.html summary:Specifies the template database from which to build this database. (This name is processed as a double-quoted identifier.)], map[description:Print the createdb version and exit. names:[-V --version] signature:-V --version source_url:/docs/18/app-createdb.html summary:Print the createdb version and exit.], map[description:Show help about createdb command line arguments, and exit. names:[-? --help] signature:-? --help source_url:/docs/18/app-createdb.html summary:Show help about createdb command line arguments, and exit.], map[description:Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket. names:[-h host --host= host] signature:-h host --host= host source_url:/docs/18/app-createdb.html summary:Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.], map[description:Specifies the TCP port or the local Unix domain socket file extension on which the server is listening for connections. names:[-p port --port= port] signature:-p port --port= port source_url:/docs/18/app-createdb.html summary:Specifies the TCP port or the local Unix domain socket file extension on which the server is listening for connections.], map[description:User name to connect as. names:[-U username --username= username] signature:-U username --username= username source_url:/docs/18/app-createdb.html summary:User name to connect as.], map[description: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. names:[-w --no-password] signature:-w --no-password source_url:/docs/18/app-createdb.html summary: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.], map[description:Force createdb to prompt for a password before connecting to a database. This option is never essential, since createdb will automatically prompt for a password if the server demands password authentication. However, createdb will waste a connection attempt finding out that the server wants a password. In some cases it is worth typing -W to avoid the extra connection attempt. names:[-W --password] signature:-W --password source_url:/docs/18/app-createdb.html summary:Force createdb to prompt for a password before connecting to a database.], map[description: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. This can be a connection string . If so, connection string parameters will override any conflicting command line options. names:[--maintenance-db= dbname] signature:--maintenance-db= dbname source_url:/docs/18/app-createdb.html summary: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. This can be a connection string . If so, connection string parameters will override any conflicting command line options.]