I’m trying to test my retool apps on data in different schemas of a postgres database (“test” and “prod”).
I’d like to dynamically be able to switch between those schemas without having to edit all of the sql queries that reference them within the app (where, for example, I have a query like select * from test.users).
Here’s what I’ve tried to no avail:
-Connect to the db with a connection string that specifices the schema (doesn’t seem to work per this issue: Selecting schema for CSV upload )
-Set a state variable in the app that references the schema and puts it into the query (retool renders that string as $1 within the sql query
Any thoughts on how to do this?