Postgres Pro
Downloads
Home   >   mailing lists

Thread: Accessing template0 tables

Accessing template0 tables

From
"Dylan Milks"
Date:
Hi.
 
Could someone please tell me how to access the template0 tables through PgAdmin. I'm using PgAdmin 1.4.12 and Postgres 7 something.
 
If I log in as "postgres", and click on the template0 table, it won't expand and a big red "X" goes over the icon.
 
How can I get around this?
 
Thanks,
Dylan Milks

Re: Accessing template0 tables

From
Tom Lane
Date:
"Dylan Milks" <DMilks@greenridge.ca> writes:
> Could someone please tell me how to access the template0 tables through PgA=
> dmin.

You're not supposed to be able to.

That database exists essentially as a backup for the original state of
template1; allowing people to connect to it would open the possibility
of people changing it, which is exactly what they must not do.

            regards, tom lane