How to specify a postgres schema in the connection string? #2654
Unanswered
cs-clarence
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I tried this but query macros don't find the tables:
postgres://root:password@localhost:5432/some_database?sslmode=disable&schema=some_schema
I couldn't find any way to specify the schema in the connection string in the docs.
Specifying the qualified names (
some_schema.some_table
instead of justsome_table
) in the queries worked but I want my queries to generic over the schema.I've tried creating different users for each schema and search their search_path to that schema. That worked but I'd rather not do that again in the future.
Beta Was this translation helpful? Give feedback.
All reactions