PostgreSQL with SQL Developer Issue

postgresql oracle-sqldeveloper

JB11 · Jan 17, 2014 · Viewed 15.6k times · Source

I added my Third Party JDBC drivers for PostgreSQL, the tab shows up.

However, after I fill in the Username/Pwd and Hostname/Port and then select Choose Database - I get:

Failure -FATAL: database "user1" does not exist

Anyone else having this issue?

The JDBC driver I am using is postgresql-8.4-701.jdbc4.jar.

Answer

If you have a different user and db name, SQLDevelopper 4.1 works with this workarround:

username: testuser
password: mypass
Host: 127.0.0.1:1234/testdb?
Port: 1234

Don't forget the "?" character. Then Select Database becomes available and connection works.

Thanks to Piperopoulos who helped me in this post: Oracle SQL Developer and PostgreSQL

Note that schema and tables are not listed by SQLDevelopper. You can use this request to list them manually:

select * from pg_catalog.pg_tables;