Hi, is it possible so set the search_path to a specific schema for the duration of a session? Or is there any other way to "connect" to a schema so all table names are relative to it?
My use case is that I have a .sql file with many queries and a set search_path to schema at the top. If I run the file as a whole it works fine, but when I try to run individual queries it fails because the search_path hasn't been permanently set and the tables aren't found.
Hi, is it possible so set the
search_pathto a specific schema for the duration of a session? Or is there any other way to "connect" to a schema so all table names are relative to it?My use case is that I have a .sql file with many queries and a
set search_path to schemaat the top. If I run the file as a whole it works fine, but when I try to run individual queries it fails because thesearch_pathhasn't been permanently set and the tables aren't found.