Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

CREATE DATABASE

Creates a new database.

Syntax

Copy
CREATE DATABASE database_name [ WITH ] [ OWNER [=] db_owner ] [ CONNECTION LIMIT { limit | UNLIMITED } ]

Parameters

database_name

Name of the new database. For more information about valid names, see Names and Identifiers.

WITH

Optional keyword.

OWNER

Specifies a database owner.

=

Optional character.

db_owner

Username for the database owner.

CONNECTION LIMIT { limit | UNLIMITED }

The maximum number of database connections users are permitted to have open concurrently. The limit is not enforced for super users. Use the UNLIMITED keyword to permit the maximum number of concurrent connections. The limit of concurrent connections for each cluster is 500. A limit on the number of connections for each user might also apply. For more information, see CREATE USER. The default is UNLIMITED. To view current connections, query the STV_SESSIONS system view.

Note

If both user and database connection limits apply, an unused connection slot must be available that is within both limits when a user attempts to connect.

CREATE DATABASE Limits

Amazon Redshift enforces these limits for databases.

  • Maximum of 60 user-defined databases per cluster.

  • Maximum of 127 bytes for a database name.

  • Cannot be a reserved word.

Examples

The following example creates a database named TICKIT and gives ownership to the user DWUSER:

Copy
create database tickit with owner dwuser;

Query the PG_DATABASE_INFO catalog table to view details about databases.

Copy
select datname, datdba, datconnlimit from pg_database_info where datdba > 1; datname | datdba | datconnlimit -------------+--------+------------- admin | 100 | UNLIMITED reports | 100 | 100 tickit | 100 | 100