NAME createdb - create a new PostgreSQL database SYNOPSIS createdb [ connection-option ...] [ option ...] [ dbname [ description ]] DESCRIPTION ... createdb creates a new PostgreSQ…option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGIN ... specified, NOSUPERUSER…option [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGIN ... SUPERUSER property and c…default is to set no limit. -d --createdb The new user will be allowed ... create databases. -D --no-createdb The new user will not be allowed to create databasessuperuser or have the special CREATEDB privilege. See CREATE ROLE ( CREATE_ROLE (7)). By default ... cloned by any user with CREATEDB privileges; if false (the default), then only …superuser owners must also have the CREATEDB privilege. The current database cannot be renamed. (Connect ... owning role, and you must have the CREATEDB privilege. (Note that super…option [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGINoption [ ... ] ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGINdump into a new database called newdb: $ createdb -T template0 newdb $ pg_restore -d newdbDROP DATABASE demo; SEE ALSO createdb (1), DROP DATABASE ( DROP_DATABASEprogram [ --cluster version / cluster ] [...] ( client-program : psql , createdb , dropuser , and all other client programs installedoption [ ... ] where option can be: SUPERUSER | NOSUPERUSER | CREATEDB | NOCREATEDB | CREATEROLE | NOCREATEROLE | INHERIT | NOINHERIT | LOGIN | NOLOGINprogram [ --cluster version / cluster ] [...] ( client-program : psql , createdb , dropuser , and all other client programs installed