CREATE DATABASE(7) SQL Commands CREATE DATABASE(7) NAME CREATE DATABASE - SYNOPSIS CREATE DATABASE name [ [ WITH ] [ OWNER [=] dbowner ] [ LOCATION [=] 'dbpath' ] [ TEMPLATE [=] template ] [ ENCODING [=] encoding ] ] DESCRIPTION CREATE DATABASE PostgreSQL CREATEDB CREATE USER [create_user(7)] OWNER CREATEDB initlocation[initlocation(1)] 'PGDATA2' ALLOW_ABSOLUTE_DBPATHS ' '/usr/local/pgsql/data' In either case, the final path name must be absolute and must not contain any single quotes. template1 TEMPLATE = name TEMPLATE = template0 PostgreSQL template1 PARAMETERS name dbowner DEFAULT dbpath DEFAULT template DEFAULT template1 encoding 'SQL_ASCII' DEFAULT NOTES CREATE DATABASE block. "could not initialize database directory" DROP DATABASE [drop_database(7)] createdb[createdb(1)] ``Managing Databases'' template1template1 "COPY DATABASE" ``Managing Databases'' EXAMPLES CREATE DATABASE lusiadas; ~/private_db shell shell: mkdir private_db initlocation ~/private_db psql CREATE DATABASE elsewhere WITH LOCATION '/home/olly/private_db'; COMPATIBILITY SQL CREATE DATABASE Postgresql man man https://github.com/man-pages-zh/manpages- zh SQL - Language Statements 2003-11-02 CREATE DATABASE(7)