Using phpPg Admin

Using phpPgAdmin

1. Click on the PgSQL icon in the quick access section of your control panel.

2. Click on the name of your database you wish to configure under PgSQL databases table.

3. Click on "Built in phpPgAdmin control panel" to launch the phpPgAdmin control panel.

You will then be brought to the login page.

4. Enter a database username and password and click the login button ignoring the other two options.

5. Click on the name of your database to view the options you have available to you.

From here you can create/delete tables, views, sequences, functions

and domains. Also note that the top menu provides you with more options.

Accounts - this allows you to edit any database users accounts.

Reports - allows you to view reports on the usage of your database.

SQL - probably the most important area of phpPgAdmin.

This allows you to test your database, add schemas modify privileges

for your users and also administer the database (analyze and vacuum it)