On 05/27/2013 11:29 AM, Moshe Jacobson wrote:
How can I show the value of search_path for the database, the user and
the session?
I ask because I cannot explain the following:
$ psql -U postgres -d ises
psql (9.1.4)
Type "help" for help.
postgres@moshe=>devmain:ises=# show search_path;
search_path
-------------------
public, audit_log
(1 row)
postgres@moshe=>devmain:ises=# alter database ises set search_path
to public, auditlog;
ALTER DATABASE
postgres@moshe=>devmain:ises=# \q
$ psql -U postgres -d ises
psql (9.1.4)
Type "help" for help.
postgres@moshe=>devmain:ises=# show search_path;
search_path
-------------------
public, audit_log
(1 row)
Is the below what you are looking for?
http://www.postgresql.org/docs/9.2/static/runtime-config-client.html
"The current effective value of the search path can be examined via the
SQL function current_schemas (see Section 9.25). This is not quite the
same as examining the value of search_path, since current_schemas shows
how the items appearing in search_path were resolved."
Section 9.25:
http://www.postgresql.org/docs/9.2/static/functions-info.html
Thanks.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
