Connecting to PostgreSQL DB using Oracle SQL Developer

by admin on June 27, 2016

SQLDeveloper-Logo

Oracle SQL Developer 4.x surely does support connections to PostgreSQL DB. you should download JDBC driver for Postgres from here: http://jdbc.postgresql.org/download.html)

If you are using the 1.6 then you should use the JDBC4 version. you can check installed JVM java version on GNU/Linux by running below command:

If you are using 1.7 then you should use the JDBC41 version.

If you are using 1.8 then you should use the JDBC42 version

If you are using a java version older than 1.6 then you will need to use a JDBC3 version of the driver, which will by necessity not be current
after downloading suitable JDBC package based on installed JVM version on your machine, in SQL Developer go to:

Tools → Preferences, Database → Third Party JDBC Drivers

and add the downloaded jar file. now just make a new Database Connection and instead of Oracle, select PostgreSQL tab and connect to your database and enjoy! 🙂

Leave your comment

Required.

Required. Not published.

If you have one.