| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Matthew Seaborn <Matthew(dot)Seaborn(at)performgroup(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Search Path vs Synonyms |
| Date: | 2009-07-24 07:56:32 |
| Message-ID: | 9837222c0907240056s12d33573p106d0012d8f20aca@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jul 24, 2009 at 09:38, Matthew
Seaborn<Matthew(dot)Seaborn(at)performgroup(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefano Nichele | 2009-07-24 08:11:39 | Re: user/grant - best practices handling permission in production system |
| Previous Message | John R Pierce | 2009-07-24 07:52:11 | Re: Search Path vs Synonyms |