A multiplatform GUI tool called pgAdmin is available for managing and querying PostgreSQL databases. It is available at www.pgadmin.org.
For Windows platforms, an executable installation program is available.
For Debian platforms, don't install the package from the Debian web site. Instead,
through a little config file magic, a Debian package direct from pgAdmin can be installed.
First, you'll need to determine your nearest mirror. Choose a
mirror, and
past it in the following format into /etc/apt/sources.list:
deb [MIRROR URL]/pgadmin3/release/debian testing pgadmin
You should then be able to run the following commands to get it installed:
apt-get update
apt-get install pgadmin3
You can start pgadmin through the command pgadmin3. In order to manage the database,
you'll have to login first as postgres, or try this simple expedient (warning this is not
very secure for your database). Place the following line into
/etc/postgresql/7.4/main/pg_hba.conf:
host all postgres 127.0.0.1 255.255.255.255 trust
In pgadmin, you'll need to connect to the database. You can connect to a specific
database
through existing credentials, or if you are looking to create new databases, you should
connect via the above credentials and connect to template1.