Re: 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/