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.

Hey @cstork ! Looks like you can set the search_path for individual queries when you wrap them in a transaction. ie: [search_path] The same query fails when run against the public (default) schema. [not_in_Public_schema]

Setting search_path for Postgres Resources

💬 Queries and Resources

cstork November 8, 2023, 5:04pm 2

I also tried currentSchema as connection option name, to no avail. :-/

BTW, this topic seems related.

Topic		Replies	Views
Setting search_path for a postgres resource connection 💬 Queries and Resources	4	812	January 29, 2025
How to Set search_path for a Postgres Resource in Retool 💬 Queries and Resources resource-connection , sql , postgres , tips-and-tricks , postgresql	2	72	February 17, 2026
Dynamically set schema for postgres resource? 💬 Queries and Resources sql	2	3116	August 2, 2023
PostgreSQL Connection Options (application_name) 💬 Queries and Resources	4	219	February 24, 2025
Can't create any new Postgres connections 💬 Queries and Resources bug	2	119	March 14, 2025

Setting search_path for Postgres Resources

Related topics