Using graphical administration tools
Graphical administration tools are often requested by system administrators.
PostgreSQL has a range of tool options. The two most popular options are as follows:
- pgAdmin3
- phpPgAdmin
We're going to describe pgAdmin3 in more detail here because it is installed by default with the PostgreSQL Windows installer. That most likely makes it the most popular interface, even though many people choose to use server software running on Linux or variants.
How to do it…
pgAdmin3 is a client application that sends and receives SQL to PostgreSQL, displaying the results for you to browse. One pgAdmin client can access many PostgreSQL servers, and a PostgreSQL server can be accessed by many pgAdmin clients.
pgAdmin3 is usually named ...
Get PostgreSQL 9 Administration Cookbook - Second 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.
