By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

Accessing template0 tables

P: n/a
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

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Dylan Milks" <DM****@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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.