| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Howto see template objects in PGAdmin3 |
| Date: | 2013-02-14 11:23:25 |
| Message-ID: | 1360841005.2044.14.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2013-02-14 13:07:05 | Re: Join query query |
| Previous Message | Guillaume Lelarge | 2013-02-14 11:20:01 | Re: Visual query builder for PosgreSQL? |