Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer won't display tables for PostgreSQL connection

jansohnNov 25 2015 — edited Dec 21 2015

I'm experiencing a similar problem already discussed here () which didn't offer a solution.

I can successfully connect to the PostgreSQL DB but as soon as I try to open schemata / tables / etc. an error window pops up saying "ERROR: syntax error at or near ""CATALOG_NAME"" Position: 31 Vendor code 0".

postgresql_sqlDeveloper.jpg

I tried all kinds of different combinations on Windows and Linux:

SQL Developer version: 4.1.2.20.64

Oracle JDK: 1.8.0_51, 32bit, Windows 7 (also tried 1.8.0_60, 64bit, SLES10)

PostgreSQL JDBC driver: postgresql-9.4-1205.jdbc42.jar (also tried jdbc3, jdbc4, jdbc41)

PostgreSQL Server: 8.1.23-0.11.1, 64bit, SLES10

One person (@"jmarton") seemed to get it working. Otherwise I could only find answers that the listing won't work (i.e. http://stackoverflow.com/a/28671213/3375325). Would be great if someone could help with or fix this issue. I can provide debug logs if I'm told how to produce them!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 18 2016
Added on Nov 25 2015
7 comments
3,323 views