> -----Original Message-----
> From: Mike Hedman [mailto:mikehedman@yahoo.com]
> Sent: 06 November 2001 04:52
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Connect problem
>
>
> Hi all,
>
> In pgAdmin II when I connect to my database I only see
> template0 in my list of databases, though template1 is where
> all my stuff is.
>
> I'm a newbie, but I have things mostly set up correctly with
> Postgresql 7.1.3 on cygwin. I'm able to access my tables
> using jsp's, so I'm pretty sure the plumbing is working correctly.
>
> Is there a setting in pgAdmin that I'm missing?
Hi Mike,
Try switching on 'system Objects' on the view menu - template1 is classed as
a system object.
I would suggest however that you *not* use template1 for your data; there
are 2 template databases by default, template0 & template1. template0 is a
blank database that cannot be modified, but template1 (which is the default
and is copied when you create a new database) is a blank database that can
be modified. This is to allow system administrators to add objects to
template1 that they want to appear in all new databases. Typically this
might include the definitions for pl/pgsql (or another procedural language),
or some useful functions.
Hth, regards, Dave.