Setting search_path "globally" across sessions through startup/init sql commands (used to work) #120
Description
On earlier versions of gizmosql I was able to have a init file which ended with a statement to set the search_path, like:
set search_path='db1.main,db2.main,main';
For users this meant that the tables in db1 and db2 didn't require prefixing in queries and db1 could be attached read only while temp tables written in db2 could be persisted across sessions.
Now it appears that the search_path from the init file is not applied to new sessions (and I can't get 'set global search_path' to work).
Since 'set search_path' is session scoped, I'd like somehow to have this setting for the search path as made in the init sql file be "transferred" or picked up automatically by new sessions.
Otherwise clients will need to always initiate their sessions with a query to set the search path as the very first statement after connecting.