I just tried as follows:
ALTER ROLE dev SET search_path TO bep;
Then ran a bunch of SQL commands after connecting to the user dev. But it
fails because it is looking for the "public" schema. I am not sure how this
"ALTER ROLE" works.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Patch-to-allow-setting-schema-search-path-in-the-connectionURL-tp2174512p5820021.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.