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 mo...@neadwerx.com | www.neadwerx.com "Quality is not an act, it is a habit." -- Aristotle