Re: Create Extension search path

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