> -----Original Message-----
> From: James Dean [mailto:jfdean@ihug.com.au]
> Sent: 04 March 2002 21:34
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] beginner problem connecting to database
>
>
> Hi all,
>
> Okay, it's stupid; how do I connect to the database that I
> want to use, rather that template1? Other that
> Tools|options|master database. I'm trying out Postgres and
> PGAdmin, and so far I can't get past this reeealy simple problem.
>
Hi,
pgAdmin allows you to browse/use an entire PostgreSQL server. In order to
examine that server, a connection is first made to the Master Database (99%
of the time, template1 should be fine for this) which is used to retrieve a
a list of the other databases.
Once you have connected, you can either create a new database (try a right
click over the treeview or listview) or double click the Databases icon on
the treeview to list the existing databases on the server. pgAdmin 1.2.0 and
earlier will open a connection to all databases at this point and you can
just browse through them and the objects within them using the treeview (the
current development code only opens connections when you actually select a
database). If you wish to enter an SQL query by hand, look at the 'Current
Database' in the status bar - when you open the SQL Window, it will used
with the current database at the time it was opened.
HTH, Regards, Dave.
