2.3.17 CREATE DATABASE

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.17 CREATE DATABASE

CREATE DATABASE -- create a new database
CREATE DATABASE creates a new database.
To create a database, you must be a superuser or have the special CREATEDB privilege. Normally, the creator becomes the owner of the new database. Non-superusers with CREATEDB privilege can only create databases owned by them.
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 directory, a full disk, or other file system problems.

2 The SQL Language : 2.3 SQL Commands : 2.3.17 CREATE DATABASE

Table of Contents Previous Next