Whilst I need EDB for a few of their features, I am keen to keep as PSQL compliant as possible.
Thanks for the help
ALTER USER userid SET search_path TO schema1,schema2;
worked nicely.
-----Original Message-----
From: Magnus Hagander [mailto:magnus@hagander.net]
Sent: 24 July 2009 08:57
To: Matthew Seaborn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Search Path vs Synonyms
On Fri, Jul 24, 2009 at 09:38, Matthew
Seaborn<Matthew.Seaborn@performgroup.com> wrote:
> Ah, I am actually using EnterpriseDB (a commercial 'fork' of PSQL) which does have synonyms.
For support on EnterpriseDB you should contact EnterpriseDB, not the
PostgreSQL community. We can only answer about the opensource product.
> Is it possible set define the default search_path for a given user?
In the community version you can. I don't know if this works in
EnterpriseDB. You'd just use
ALTER USER userid SET search_path='schema1,schema2'
--
Magnus Hagander
Self: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
________________________________________________________________________
CONFIDENTIALITY - This email and any files transmitted with it, are confidential, may be legally privileged and are
intendedsolely for the use of the individual or entity to whom they are addressed. If this has come to you in error,
youmust not copy, distribute, disclose or use any of the information it contains. Please notify the sender immediately
anddelete them from your system.
SECURITY - Please be aware that communication by email, by its very nature, is not 100% secure and by communicating
withPerform Group by email you consent to us monitoring and reading any such correspondence.
VIRUSES - Although this email message has been scanned for the presence of computer viruses, the sender accepts no
liabilityfor any damage sustained as a result of a computer virus and it is the recipient�s responsibility to ensure
thatemail is virus free.
AUTHORITY - Any views or opinions expressed in this email are solely those of the sender and do not necessarily
representthose of Perform Group.
COPYRIGHT - Copyright of this email and any attachments belongs to Perform Group, Companies House Registration number
6324278.