CREATEDB(1)       PostgreSQL Client Applications      CREATEDB(1)


NAME
       createdb - create a new PostgreSQL database


SYNOPSIS
       createdb [ option... ]  [ dbname ]  [ description ]

DESCRIPTION
       createdb creates a new PostgreSQL database.

       Normally,  the  database  user  who  executes this command
       becomes the owner of the new database.  However a  differ-
       ent  owner can be specified via the -O option, if the exe-
       cuting user has appropriate privileges.

       createdb is  a  wrapper  around  the  SQL  command  CREATE
       DATABASE [create_database(7)].  There is no effective dif-
       ference between creating databases via  this  utility  and
       via other methods for accessing the server.

OPTIONS
       createdb accepts the following command-line arguments:

       dbname Specifies  the  name of the database to be created.
              The  name  must  be  unique  among  all  PostgreSQL
              databases  in this cluster.  The default is to cre-
              ate a database with the same name  as  the  current
              system user.

       description
              Specifies a comment to be associated with the newly
              created database.

       -D tablespace

       --tablespace tablespace
              Specifies the default tablespace for the  database.

       -e

       --echo Echo the commands that createdb generates and sends
              to the server.

       -E encoding

       --encoding encoding
              Specifies the character encoding scheme to be  used
              in  this  database. The character sets supported by
              the PostgreSQL server are described in the documen-
              tation.

       -O owner





Application                 2005-11-05                          1





CREATEDB(1)       PostgreSQL Client Applications      CREATEDB(1)


       --owner owner
              Specifies  the  database  user who will own the new
              database.

       -q

       --quiet
              Do not display a response.

       -T template

       --template template
              Specifies the template database from which to build
              this database.


       The  options  -D,  -E, -O, and -T correspond to options of
       the  underlying  SQL   command   CREATE   DATABASE   [cre-
       ate_database(7)];  see  there  for  more information about
       them.

       createdb also accepts the following command-line arguments
       for connection parameters:

       -h host

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

       -p port

       --port port
              Specifies the TCP port or  the  local  Unix  domain
              socket  file  extension on which the server is lis-
              tening for connections.

       -U username

       --username username
              User name to connect as

       -W

       --password
              Force password prompt.


ENVIRONMENT
       PGDATABASE
              If set, the name of the database to create,  unless
              overridden on the command line.



Application                 2005-11-05                          2





CREATEDB(1)       PostgreSQL Client Applications      CREATEDB(1)


       PGHOST

       PGPORT

       PGUSER Default  connection  parameters. PGUSER also deter-
              mines the name of the database to create, if it  is
              not specified on the command line or by PGDATABASE.

DIAGNOSTICS
       In  case  of  difficulty,  see   CREATE   DATABASE   [cre-
       ate_database(7)]  and psql(1) for discussions of potential
       problems and error messages.  The database server must  be
       running at the targeted host. Also, any default connection
       settings and  environment  variables  used  by  the  libpq
       front-end library will apply.

EXAMPLES
       To  create  the  database  demo using the default database
       server:

       $ createdb demo
       CREATE DATABASE

       The response is the same as you  would  have  gotten  from
       running the CREATE DATABASE SQL command.

       To create the database demo using the server on host eden,
       port 5000, using the LATIN1 encoding scheme with a look at
       the underlying command:

       $ createdb -p 5000 -h eden -E LATIN1 -e demo
       CREATE DATABASE "demo" WITH ENCODING = 'LATIN1'
       CREATE DATABASE


SEE ALSO
       dropdb(1),  CREATE DATABASE [create_database(7)], Environ-
       ment Variables (the documentation)



















Application                 2005-11-05                          3