PostgreSQL showing tables problem
Hi all,
I have a problem with PostgreSQL database connected on DataGrip. The connection is successful and I see every database on the server, but I can't see SCHEMA, TABLES, ... etc. in the databases. I can't see nothing below database level. I try synchronization many times. I'm using 'postgres' user. It's no error message to understand what is the problem.
Every other SQL server that I use is OK. (MySQL and MSSQL Server)
DataGrip version 2016.2 Build #DB-162.1122.5
PostgreSQL version 9.5.3
JDBC Driver - I try postgresql-9.4.1201 (standard driver downloaded from DataGrip) and try also postgresql-9.4.1209 (last driver downloaded from PostgreSQL site)
Screenshot here - https://gyazo.com/d1324f362384bededc8b7f13d065fc50
Please sign in to leave a comment.
I'm experiencing the same issue.
The screenshot is dead
I found what is the problem
Just for every database I change the URL in Data Sources
URL: jdbc:postgresql://**.**.**.**:5432/my_database
So, all is ok now, right?
Yes, it's right.
I have this same problem, I can connect but all i see is:
connectionName -> databaseName
I dont see the tables
please can anyone help?
If i use the same credentials on say Psequal, it connects fine
I got the same problem.
My env:
IntelliJ IDEA 2017.2
Build #IU-172.3317.76, built on July 15, 2017
JRE: 1.8.0_152-release-915-b5 amd64
JVM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
Linux 4.8.0-58-generic
psql (9.5.7)
the error is
```
[42725] org.postgresql.util.PSQLException: ERROR: function array_agg(bigint) is not unique
Indice : Could not choose a best candidate function. You might need to add explicit type casts.
Position : 255.
ERROR: function array_agg(bigint) is not unique
Indice : Could not choose a best candidate function. You might need to add explicit type casts.
Position : 255
```
I have the same problem connecting to PostgreSQL 9.6.x. It worked for a short while, but now I can't see the schema.
I can still execute commands to search and modify the databases, but the IDE does not see the schema and is unable to provide and help writing commands.
This is very irritating. Everything works fine with SQL Server.
Datagrip is really excellent - apart from this issue.
I just updated DataGrip to 2017.3 built 5th December 2017 and I can now see my Postgresql schemas. Great!
Any update of this one ? still not working in IntelliJ neither in DataGrip.
Why ? :(
@Tony Chemit
Can I ask you for a screenshot? Did you try to choose schemas to be visible?
Also, the screenshot of Schemas in data source properties will be useful.
Try the following:
Go to your PostgreSQL database in "Data Sources and Drivers". On the options tab select "Introspect using JDBC metadata".
Does this help?
If it helps, it isn't normal anyway. For PostgreSQL, DataGrip MUST introspect without using JDBC metadata.
@Maxim
yes i check some schema
Now I try to activate Introspect with JDBC metadata, and I got some success!
you can see I got some tables in my schema, but I still got an error. So @Maxim why DataGrip MUST not introspect with JDBC metadata as it seems to work (for now...)
Works also in IntellIJ :D
@Chris yes it helps a lot, thanks.
@Tony, a huge thanks for the report! We'll fix it in the upcoming bug-fix update.
I'm having the same issue. I use the Postgres connection to access my redshift db. The tables were there as recently as a couple of days ago that I remember. You can also see that the tables are fine for my mysql connections. When I restart the program/connection, the arrows (for expanding table lists) appear and then disappear.
I'm on version 2016.3 and selected "Introspect using JDBC metadata" but that didn't help.
"Introspect using JDBC metadata" worked for me! Thanks.
Try to switch to the latest DataGrip version. It should eliminate most of the problems with introspection