Howto see template objects in PGAdmin3 - Mailing list pgsql-general

From James B. Byrne
Subject Howto see template objects in PGAdmin3
Date
Msg-id 539b383d1ff7a380e2d216618fe44b4b.squirrel@webmail.harte-lyne.ca
Whole thread Raw
Responses Re: Howto see template objects in PGAdmin3
List pgsql-general
PG-9.2
PGAdmin3-1.16.0

I have run into an old problem wherein the postgres user has ownership
of the PSQL language extension in a newly created database.  I wish to
remove this extension from template1 as the database is automatically
recreated on every test run and I am unable to specify template0 to
the test software.

I am attempting to do this from inside PGAdmin3 but I find that I no
longer see either template0 or template1 in the object tree.  Where
are they found?


--=20
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Changing Character Sets
Next
From: "René Romero Benavides"
Date:
Subject: Re: design question - repeated updates on temp or perm table.