On Fri, Jul 24, 2009 at 09:38, Matthew Seaborn<matthew.seab...@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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general