create database\(em create a new database

.nf

\fBcreatedatabase\fP dbname

\fBcreatedatabase\fP dbname [\fBwithlocation='\fPdbpath\fB'\fP]

.fi

.BR"Create database"

.BR"create database"

creates a new Postgres database. The creator becomes the administrator

of the new database.

of the new database. An alternate location can be specified as either an

environment variable known to the backend server (e.g. 'PGDATA2') or as

an absolute path name (e.g. '/home/postgres/data'). In either case, the

location must be pre-configured by

.BR initarea

createdb(1),

drop database(l),

destroydb(1),

initarea(1),

initdb(1).

createdb\(em create a database

[\c

.BR -p

port]

[\c

.BR -D

location]

[dbname]

.IR Createdb

.BR createdb

creates a new database. The person who executes this command becomes

the database administrator, or DBA, for this database and is the only

person, other than the Postgres super-user, who can destroy it.

.IR dbname

specifies the name of the database to be created. The name must be

unique among all Postgres databases.

.IRDbname

.IRdbname

defaults to the value of the

.SMUSER

environment variable.

.PP

.IRCreatedb

.IRcreatedb

understands the following command-line options:

.TP5n

.IR postmaster

process. The default is site-specific.

.TP

Specifies the alternate database location for this database.

.TP

Specifies the hostname of the machine on which the

.IR postmaster