No Postgres Schema Support?
It appears that DataGrip doesn't support PostgreSQL schemas. Even when I try to specify a schema search path manually in the URL, DataGrip always connects to the public schema. Either I'm missing something, or this is a huge oversight in DataGrip's Postgres "support."
Please sign in to leave a comment.
Actually, the answer above is not true: in Options tab from 2016.2 you choose only objects to resolve if there is a file not attached to datasource. Schema chooser now is a dropdown in the database view:
Search path for each console can be found here:
Hey Jonathan,
I'm using DG with PostgreSQL and schemas work perfectly fine for me. I do not specify any schema in the connection string, but if you check the Data Source Properties of your DB (cmd + ; on OS X) go to the Options tab and there you should find a dropdown list under the name of your DB where you can check & uncheck the schemas you want to display.
Is there a way I can set that to the default, I have selected it a few times and pressed enter to select as default, but every time I go back, it selects public again? I have multiple connections open if that helps.