PostresSql not showing all schemas
Hi,
Just installed this, it looks very useful.
Already tried MySQL and MsSQL successfully but I'm having trouble with Postgres - It's not showing all the existing schemas in my server.
It's only showing
information_schema, pg_catalog and public.
Is it a problem with my URL? The default URL "jdbc:postgresql://localhost:5432" doesn't work at all, I had to add a slash at the end of it and then I only got the 3 items I mentioned above.
Thanks,
Guy
Please sign in to leave a comment.
I'm having the same problem.
Thanks,
Ryan
Hello.
Please try to specify database name in the URL, like: jdbc:postgresql://localhost:5432/db-name
Database field in the Data Sources dialog is for that.
Regards,
Alexander.
Hello,
This works of course but it's kind of missing the point. I would like to see all databases defined on this postgres instance...
pgAdmin does it
This is a limitation of JDBC driver, and we already have requests to improve this: http://youtrack.jetbrains.com/issue/DBE-93
Not sure will it be possible to do anything with this, but at least we are aware of the problem.
Regards,
Alexander.
Hi,
I was having the same problem too, I created a new schema in an existing database and I could not see it in the explorer window on the right hand side. It looks like you can see all the schemas by going into the "Manage Data Sources" option in the context menu for your db. There is tab for schemas and you can choose which ones you want to see (or * for all of them, including new ones that are created through SQL). I am using 0xDBE version 138.2222.2
Good work JetBrains, this is shaping up to be a great product!
Mark
I got this working with a combination of the two comments:
Data Sources and Drivers -> YOUR_DATA_SOURCE -> Schemas -> Check "All databases"
Data Sources and Drivers -> YOUR_DATA_SOURCE -> Options -> Check "Introspect using JDBC metadata"
After I checked the "Introspect using JDBC metadata" once, and pulled down the initial table definitions, checking and unchecking it seemed to have no difference. Not sure why.
I got the same problem but no matter what I do the schemas are missing, the is a huge disconnection from what postgres really has vs datagrip is showing to be honest this product is not complete, there is a lot of things here missing compare to other solutions out there.
@ Alain Iskander Abrahan Paz,
Could you explain your problem in details?
Make sure you select schemas you want to work with.
I'm having the same problem. I've tried selecting all schemas or only one and always get the same error. I have the latest version of the driver and using Postgres 11. Postico has no issues accessing the data or the schema
Jack Neto,
Could you email me vasily.chernov@jetbrains.com your IDE and SQL logs?
I had this problem in Intellij IDEA Database tab.
I got the solution doing, only : Data Sources and Drivers -> YOUR_DATA_SOURCE -> Schemas -> Check "All databases"