Creating a database

In order to create a database in Postgres, you will need to have sufficient…permission, and while it's possible to assign sufficient permission to a normal…user or, say, a user that's only logged in from a particular application, it's…generally a bad idea.…So you'll normally need to have superuser permission in order to create a…database. And given that restriction, the easiest way to create a database is to…launch the pgAdmin application, where you have superuser permission by default.…

So here's the pgAdmin application.…I am going to double-click on our database here…so we get logged in, and click on Databases.…You can see here the databases that we've already created when you installed…Postgres, and the Postgres database, which is the default database it's the…administrative database--…you need that in order for the system to work,…so don't ever delete that one.…Now let's go ahead and create a database. This is very easy.…We simply select Databases in the object browser and press the magical "create…