create_database man page on UnixWare

Man page or keyword search:  
man Server   3616 pages
apropos Keyword Search (all sections)
Output format
UnixWare logo
[printable version]


       CREATE DATABASE - create a new database

	   [ [ WITH ] [ OWNER [=] dbowner ]
		  [ TEMPLATE [=] template ]
		  [ ENCODING [=] encoding ]
		  [ TABLESPACE [=] tablespace ]
		  [ CONNECTION LIMIT [=] connlimit ] ]

       CREATE DATABASE creates a new PostgreSQL database.

       To  create a database, you must be a superuser or have the special CRE‐
       ATEDB privilege.	 See CREATE USER [create_user(5)].

       Normally, the creator becomes the owner of  the	new  database.	 Supe‐
       rusers  can  create  databases owned by other users, by using the OWNER
       clause. They can even create databases owned by users with  no  special
       privileges.  Non-superusers  with  CREATEDB  privilege  can only create
       databases owned by themselves.

       By default, the new database will be created by	cloning	 the  standard
       system  database	 template1.  A	different template can be specified by
       writing TEMPLATE name. In particular, by	 writing  TEMPLATE  template0,
       you  can	 create a virgin database containing only the standard objects
       predefined by your version of PostgreSQL. This is useful if you wish to
       avoid  copying  any installation-local objects that may have been added
       to template1.

       name   The name of a database to create.

	      The name of the database user who will own the new database,  or
	      DEFAULT  to use the default (namely, the user executing the com‐

	      The name of the template from which to create the new  database,
	      or DEFAULT to use the default template (template1).

	      Character	 set  encoding	to  use in the new database. Specify a
	      string constant (e.g., 'SQL_ASCII'), or an integer encoding num‐
	      ber,  or DEFAULT to use the default encoding (namely, the encod‐
	      ing of the template database). The character sets	 supported  by
	      the PostgreSQL server are described in in the documentation.

	      The  name of the tablespace that will be associated with the new
	      database, or DEFAULT to use the template database's  tablespace.
	      This  tablespace will be the default tablespace used for objects
	      created  in  this	 database.   See   CREATE   TABLESPACE	 [cre‐
	      ate_tablespace(5)] for more information.

	      How many concurrent connections can be made to this database. -1
	      (the default) means no limit.

       Optional parameters can be written in any order,	 not  only  the	 order
       illustrated above.

       CREATE DATABASE cannot be executed inside a transaction block.

       Errors  along  the  line of ``could not initialize database directory''
       are most likely related to insufficient permissions on the data	direc‐
       tory, a full disk, or other file system problems.

       Use DROP DATABASE [drop_database(5)] to remove a database.

       The  program  createdb  [createdb(1)]  is a wrapper program around this
       command, provided for convenience.

       Although it is possible to copy a  database  other  than	 template1  by
       specifying  its	name  as the template, this is not (yet) intended as a
       general-purpose ``COPY DATABASE'' facility.  The	 principal  limitation
       is  that	 no  other  sessions can be connected to the template database
       while it is being copied. CREATE DATABASE will fail if any  other  con‐
       nection	exists	when it starts; otherwise, new connections to the tem‐
       plate database are locked out until CREATE DATABASE completes.  See  in
       the documentation for more information.

       The  CONNECTION LIMIT option is only enforced approximately; if two new
       sessions start at about the same time when just one connection ``slot''
       remains for the database, it is possible that both will fail. Also, the
       limit is not enforced against superusers.

       To create a new database:

       CREATE DATABASE lusiadas;

       To create a database sales  owned  by  user  salesapp  with  a  default
       tablespace of salesspace:

       CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace;

       To create a database music which supports the ISO-8859-1 character set:


       There  is  no  CREATE DATABASE statement in the SQL standard. Databases
       are equivalent to catalogs, whose creation is implementation-defined.

       ALTER DATABASE [alter_database(5)], DROP DATABASE [drop_database(l)]

SQL - Language Statements	  2008-01-03		     CREATE DATABASE()
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server UnixWare

List of man pages available for UnixWare

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
Vote for polarhome
Free Shell Accounts :: the biggest list on the net