Creating a Database in PostgreSQL
Creating a database in PostgreSQL is straightforward, but it must be performed by a user who has permissions to create databases in PostgreSQL—for example, initially the user named postgres
. You can then simply issue the following command from the shell prompt (not the PSQL client prompt, but a normal shell prompt):
matthew@seymour:~# su - postgres-bash-2.05b$ createdb database
where database is the name of the database you want to create.
The createdb
program is actually a wrapper that makes it easier to create databases without having to log in and use psql
. However, you can also create databases from within psql
with the CREATE DATABASE
statement. Here is an example:
CREATE DATABASE ...
Get Ubuntu Unleashed 2015 Edition: Covering 14.10 and 15.04, Tenth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.