| From: | "Alain Roger" <raf(dot)news(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | schema and roles |
| Date: | 2008-10-17 17:45:07 |
| Message-ID: | 75645bbb0810171045n1a207084kc63530856cf33152@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
several days ago i wrote a post but i did not get any answer, so i'm asking
again just in case of someone hasn't seen it.
in fact i would like to know what are the default schemas allowed or active
for a particular role.
usually it's public and $user, but how to get those information ?
i mean if i'm logged with the role "test_user", typing show search_path;
will show me all default schemas.
1. is there another place (in som pg_... table) where this information is
stored ?
2. if yes how can i get it ?
After that, i know that using alter user test_user .... i can add another
schema as default, but how to remove some ?
thanks a lot,
--
Alain
------------------------------------
Windows XP SP3
PostgreSQL 8.2.4 / MS SQL server 2005
Apache 2.2.4
PHP 5.2.4
C# 2005-2008
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-17 17:59:13 | Re: deferred triggers? |
| Previous Message | André Volpato | 2008-10-17 17:42:04 | Re: VACUUM PANIC: corrupted item pointer |