Postgre databases

This section displays your current databases and the users assigned to each one. Below this are the options which control everything to do with your postgres databases:

Creating a New Database

Simply enter the name of the database you wish to create and click the Add DB button. The DB name will be prefixed with your account username and an underscore so the full DB name will be username_dbname

Creating a User

Simply enter a username and password and click the Add User button. The username will be prefixed with your account username and an underscore so the full DB username will be username_dbusername

You can create one user which you can add to all your databases or create a different user for each database which adds to security.

Add a User to a Database

You must create a user and add them to a database before that database can be used by, for example, a PHP script.

Select the user from the first drop-down box and select the database from the second drop-down menu and click the Add User to Db button.

phpPgAdmin

You can use phpPgAdmin to administrate your Postgres databases in a web based environment.