Re: [postgis-users] pg_dump -s should use add_geometrycolumn(...) - Mailing list 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