Re: Create Extension search path

From: Richard Huxton <dev(at)archonet(dot)com>
To: Roger Niederland <roger(at)niederland(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Create Extension search path
Date: 2011-09-29 09:35:18
Message-ID: 4E843BD6.2050501@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message depstein 2011-09-29 10:00:48 Feature request: improving ENUM type manipulation
Previous Message Richard Huxton 2011-09-29 09:25:36 Re: stored procs