search_path for database vs user vs session

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(at)moshe=>devmain:ises=# show search_path;
search_path
-------------------
public, audit_log
(1 row)

postgres(at)moshe=>devmain:ises=# alter database ises set search_path to
public, auditlog;
ALTER DATABASE

postgres(at)moshe=>devmain:ises=# \q
$ psql -U postgres -d ises
psql (9.1.4)
Type "help" for help.

postgres(at)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(at)neadwerx(dot)com | www.neadwerx.com

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