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

From Guillaume Lelarge
Subject Re: Howto see template objects in PGAdmin3
Date
Msg-id 1360841005.2044.14.camel@localhost.localdomain
Whole thread Raw
In response to Howto see template objects in PGAdmin3  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
Responses Re: Howto see template objects in PGAdmin3
List pgsql-general
On Tue, 2013-02-12 at 15:32 -0500, James B. Byrne wrote:
> 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?
>

You first need to check the "Show System Objects in the treeview" in the
Options dialog. Then, they'll be available in the Databases node of the
treeview.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Visual query builder for PosgreSQL?
Next
From: Amit Kapila
Date:
Subject: Re: Join query query