search_path for database vs user vs session

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx | www.neadwerx.com

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