Accessing template0 tables

Started by Dylan Milksabout 22 years ago2 messagesgeneral
Jump to latest
#1Dylan Milks
DMilks@greenridge.ca

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dylan Milks (#1)
Re: Accessing template0 tables

"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