| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, tgl(at)sss(dot)pgh(dot)pa(dot)us, nicolas(dot)ribot(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org, PostGIS Users Discussion <postgis-users(at)postgis(dot)refractions(dot)net> |
| Subject: | Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...) |
| Date: | 2012-08-30 08:52:16 |
| Message-ID: | 503F29C0.2020906@ringerc.id.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/30/2012 04:40 PM, Willy-Bas Loos wrote:
> (why not a separate catalog with all the functions and types etc? hmz
> maybe because you'd need to change the search_path, which is in
> postgresql.conf)
You can choose which schema an extension goes into when you CREATE
EXTENSION. See the documentation.
You don't have to set search_path in postgresql.conf ; it can be set
per-session with `SET search_path` and can also be set per-user,
per-database and per-function.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nicola Cisternino | 2012-08-30 09:16:40 | Re: String comparision in PostgreSQL |
| Previous Message | Craig Ringer | 2012-08-30 08:49:41 | Re: [BUGS] PostGreSQL pgdac - C++ Builder 2007 |