v2.23 Preview Preview release - not for production v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support v2.18 STS Stable release with standard-term support v2.14 LTS Stable release with long-term support Unsupported versions

CREATE DATABASE

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_name ]  
                            [ ENCODING [ = ] encoding ]  
                            [ LC_COLLATE [ = ] lc_collate ]  
                            [ LC_CTYPE [ = ] lc_ctype ]  
                            [ ALLOW_CONNECTIONS [ = ] allowconn ]  
                            [ CONNECTION LIMIT [ = ] connlimit ]  
                            [ IS_TEMPLATE [ = ] istemplate ]  
                            [ COLOCATION [ = ] { 'true' | 'false' } ]

create_database

CREATEDATABASEnamecreate_database_options

create_database_options

WITHOWNER=user_nameTEMPLATE=template_nameENCODING=encodingLC_COLLATE=lc_collateLC_CTYPE=lc_ctypeALLOW_CONNECTIONS=allowconnCONNECTIONLIMIT=connlimitIS_TEMPLATE=istemplateCOLOCATION=truefalse

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

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.

COLOCATION

Specify true if tables for this database should be colocated on a single tablet by default. See Colocated tables for details on when colocated tables are beneficial.

Default is false and every table in the database will have its own set of tablets.

Examples

Create a colocated database

yugabyte=# CREATE DATABASE company WITH COLOCATION = true;

In this example, tables in the database company will be colocated on a single tablet by default.

See also