Database Reference
In-Depth Information
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 if 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 just pgAdmin. The
3
at the end has a long history, but isn't that
important. It is not the release level. Current release level is 1.12 at time of writing.
When you start pgAdmin, you will be prompted to register a new server, as shown in the
following screenshot:
As shown in the preceding screenshot, note the five basic connection parameters, as well as
other information.
