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

10 comments
Comment actions Permalink

I'm having the same problem.

Thanks,
Ryan

0
Comment actions Permalink

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.

0
Comment actions Permalink

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

1
Comment actions Permalink

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.

0
Comment actions Permalink

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

2
Comment actions Permalink

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.

5
Comment actions Permalink

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.

0
Comment actions Permalink

@ Alain Iskander Abrahan Paz,

Could you explain your problem in details?

Make sure you select schemas you want to work with.

0
Comment actions Permalink

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

0
Comment actions Permalink

Jack Neto,

Could you email me vasily.chernov@jetbrains.com your IDE and SQL logs?

0

Please sign in to leave a comment.