How to connect to multiple PostgreSQL schemas

Get Help
1

Hello,

Is there a way to connect Metabase on an other schema than the default one "public"?
I've tried to set currentSchema=myschema as JDBC parameter but it still connected to "public".
I would like to have both "public" and "myschema" in my Metabase.

Thx fo your support!

2

Hi @felici1b
Post "Diagnostic Info" from Admin > Troubleshooting, and which version of Postgres you're querying.
All schemas should be available if the user credentials has privileges to select in the schema.

1 Like
3

Hi @flamber,
Thank for the quick answer, if that's possible I may not set it up correctly.

4

@felici1b Check the logs for any errors during the sync process - Admin > Troubleshooting > Logs.
And most people do not need to define anything in the Connection String.