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>