On Fri, 2008-10-17 at 19:45 +0200, Alain Roger wrote:
> i mean if i'm logged with the role "test_user", typing show
> search_path; will show me all default schemas.
On SHOW, the manual saith[1]:
"The function current_setting produces equivalent output" ...
SELECT current_setting('search_path');
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
