Dynamically setting schema_search_path

Is there any way for Rails to look through schema1.table1 vs
schema2.table1 depending on input from a view? eg. a link that sets a
session variable?

Did you ever find a solution to this? Running into the same issue now.