Postgres Pro
Downloads
Home   >   mailing lists

Re: Create Extension search path - Mailing list pgsql-general

From Richard Huxton
Subject Re: Create Extension search path
Date
Msg-id 4E843BD6.2050501@archonet.com
Whole thread Raw
In response to Create Extension search path  (Roger Niederland <roger@niederland.com>)
List pgsql-general
Tree view 
On 28/09/11 18:51, Roger Niederland wrote:
> To add the extension required me to change the search_path.
> Is it required that all any schema added to the search_path exist in all
> databases?

If set in the configuration file, yes (unless you want errors).

You can set it per-database or per-user though. See ALTER DATABASE or
ALTER ROLE.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: stored procs
Next
From:
Date:
Subject: Feature request: improving ENUM type manipulation