As far as I know, currently one can set the search path globally, or on a
per role bases.
I was wondering if it could be possible to have a per database search_path.
I believe this would be not only convenient, but will add flexibility.
What got me thinking of this was that I manually ste a search_path.
Connected to another database and when I came back to the original database
the search_path was gone.
At first I thought perhaps search_path could be set by database and that
changing database was blanking my change. After looking at the help for
alter database I noticed that there is no way to set the search_path by
database.