This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
version, or one of the supported versions listed above instead.
Managing a Database
Let's say you want to create a database named mydb. You can do
this with the following command:
% createdb mydb
Postgres allows you to create any number of databases at a
given site and you automatically become the database administrator
of the database you just created. Database names must have an
alphabetic first character and are limited to 16 characters in
length. Not every user has authorization to become a database
administrator. If Postgres refuses to create databases for you,
then the site administrator needs to grant you permission to create
databases. Consult your site administrator if this occurs.