Postgres Pro
Downloads
Home   >   mailing lists

search_path for database vs user vs session - Mailing list pgsql-general

From Moshe Jacobson
Subject search_path for database vs user vs session
Date
Msg-id CAJ4CxLkRMCFJr=OyetdpaDv-RwV2PqTqUrGcXe8YOz7BZ8-yFg@mail.gmail.com
Whole thread Raw
Responses Re: search_path for database vs user vs session  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view
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)

Thanks.

--
Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering
2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@neadwerx.com | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle

pgsql-general by date:

Previous
From: Nikhil G Daddikar
Date:
Subject: How to know the exact time to which the database was recovered
Next
From: Adrian Klaver
Date:
Subject: Re: search_path for database vs user vs session