You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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 thesearch_path
hasn't been permanently set and the tables aren't found.The text was updated successfully, but these errors were encountered: