Create a Database Using Createdb Command
Use the createdb command to create a database. The user who creates a database becomes its database administrator. For a complete description of the createdb command, see the Command Reference Guide.
Note: You must have the createdb privilege to create a database. For details, see the Database Administrator Guide.
To create the demodb database using the createdb command
Issue the following command:
createdb demodb
This command creates a public database named demodb on the local node in the default locations. The database is Unicode-enabled using Normalization Form C.