Provided by: manpages-zh_1.5.2-1_all bug

NAME

       CREATE DATABASE -

SYNOPSIS

       CREATE DATABASE name
           [ [ WITH ] [ OWNER [=] dbowner ]
                  [ LOCATION [=] 'dbpath' ]
                  [ TEMPLATE [=] template ]
                  [ ENCODING [=] encoding ] ]

DESCRIPTION

       CREATE DATABASE  PostgreSQL

         CREATEDB   CREATE USER [create_user(7)]

          OWNER   CREATEDB

          initlocation[initlocation(1)]

            'PGDATA2'  ALLOW_ABSOLUTE_DBPATHS     ' '/usr/local/pgsql/data' In
       either case, the final path name must be absolute and must not  contain
       any single quotes.

          template1    TEMPLATE  =   name    TEMPLATE  = template0  PostgreSQL
       template1

PARAMETERS

       name

       dbowner
                DEFAULT

       dbpath
                     DEFAULT

       template
                DEFAULT template1

       encoding
                'SQL_ASCII'  DEFAULT

NOTES

       CREATE DATABASE block.

         "could not initialize database directory"

         DROP DATABASE [drop_database(7)]

         createdb[createdb(1)]

           ``Managing Databases''

         template1template1  "COPY DATABASE"    ``Managing Databases''

EXAMPLES


       CREATE DATABASE lusiadas;

         ~/private_db  shell shell:

       mkdir private_db
       initlocation ~/private_db

         psql

       CREATE DATABASE elsewhere WITH LOCATION '/home/olly/private_db';

COMPATIBILITY

         SQL  CREATE DATABASE

       Postgresql  <laser@pgsqldb.org>