CREATE DATABASE
Attention
This page documents an earlier version. Go to the latest (v2.0)version.Synopsis
Use the CREATE DATABASE statement to create a database that functions as a grouping mechanism for database objects such as tables.
Syntax
create_database ::= CREATE DATABASE name [ create_database_options ]
create_database_options ::= [ WITH ] [ OWNER [ = ] user_name ]
[ TEMPLATE [ = ] template ]
[ ENCODING [ = ] encoding ]
[ LC_COLLATE [ = ] lc_collate ]
[ LC_CTYPE [ = ] lc_ctype ]
[ TABLESPACE [ = ] tablespace_name ]
[ ALLOW_CONNECTIONS [ = ] allowconn ]
[ CONNECTION LIMIT [ = ] connlimit ]
[ IS_TEMPLATE [ = ] istemplate ]
create_database
create_database_options
Semantics
create_database
CREATE DATABASE name
Specify the name of the database to be created. An error is raised if a YSQL database of the given name already exists.
create_database_options
[ WITH ] OWNER user_name
Specify the role name of the user who will own the new database. When not specified, the database creator is the owner.
TEMPLATE template
Specify the name of the template from which the new database is created.
ENCODING encoding
Specify the character set encoding to use in the new database.
LC_COLLATE lc_collate
Specify the collation order (LC_COLLATE).
LC_CTYPE lc_ctype
Specify the character classification (LC_CTYPE).
TABLESPACE tablespace_name
Specify the new tablespace that is associated with the database.
ALLOW_CONNECTIONS allowconn
Specify false to disallow connections to the database. Default is true, which allows connections to the database.
CONNECTION_LIMIT connlimit
Specify how many concurrent connections can be made to this database. Default of -1 allows unlimited concurrent connections.
IS_TEMPLATE istemplate
true — This database can be cloned by any user with CREATEDB privileges.
Specify false to only superusers or the owner of the database can clone it.