How do I set the Postgres search_path when connecting to a PostgreSQL resource?
I tried setting it as a "Connection option" but it does not seem to have any effect.
1 Like
I also tried currentSchema as connection option name, to no avail. :-/
BTW, this topic seems related.
Hey @cstork! Looks like you can set the search_path for individual queries when you wrap them in a transaction. ie:
The same query fails when run against the public (default) schema.
