: Matthew Seaborn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Search Path vs Synonyms
On Fri, Jul 24, 2009 at 09:38, Matthew
Seaborn wrote:
> Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does
> have synonyms.
For support on EnterpriseDB yo
Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does
have synonyms.
Is it possible set define the default search_path for a given user?
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: 24 July 2009 07:22
To: Matthew Seab
Given the situation where a user connecting to the database needs access to two
separate schemas: the primary schema which contains the data they will be
updating and a second schema which contains read-only reference data, used by
many users, that will be using in joins on queries.
I don't wan
