Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.15 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.

3 The SQL Language : 3.3 SQL Commands : 3.3.15 CREATE DATABASE

Table of Contents Previous Next