I see that some people wonder if Oracle SQL Developer can be used with PostgreSQL. I wrote a blog post to show how you can configure Oracle SQL Developer to connect Microsoft SQL Server and MySQL. You can use the same method to configure SQL Developer for PostgreSQL. First we need to download a compatible JDBC driver from PostgreSQL site. Latest version of SQL Developer uses JDK 1.7, so we can download the JDBC41 Postgresql Driver:

postgresjdbc

Then we open Oracle SQL Developer, open preferences, database section and third party JDBC driver.

addjdbcdriver

Click “Add Entry” button, pick the JAR file you downloaded, click OK to make it enabled.

postgresisready

Now you can defined connections for PostgreSQL databases and connect them. You’ll see that only basic features work (such as running queries). I encountered problems even when browsing indexes but it’s better than nothing.

21 Responses to “Configuring Oracle SQL Developer for PostgreSQL”

  1. Merhaba Gökhan Bey,

    Gerçekten çok faydalı oldu, teşekkür ederim. postgreSQL ile güzel bir tool arayışındaydım. en azından bildiğimiz bir developer tool ile postgreSQL ile çalışmak çok güzel bir duygu

  2. mehmetsülün says:

    merhaba,

    4.0.2  ve 4.0.3 sürünüyor  ben  açamadım  çok yavaş  sizdede  durum  aynımı acaba?

    • Mehmet kardeş yabancı forumlarda da araştırdım benzer sorunlar yaşanmış. Çözüm olarak da Oracle SQL Developer 3.2 kullanın diyorlar. 3.2 çok iyi çalışıyor.
      Bilginize.

  3. Hi,

    Do you know how to access Teradata using SQLDeveloper. I downloaded jar file and is still showing error?

    regards,

    Manoj.V

    • Gokhan Atil says:

      Hi Manoj,

      I don’t have access to any Terradata box. If Terradata still provides a demo VM, I may try it. What kind of error do you get?

  4. amihay gonen (@agonen) says:

    Do you know if sqldeveloper can auto complete table names of fields for postgres data source ?

  5. Thomas says:

    Thanks for the post.

  6. Hi Gakhan,

    I have SQL Developer 3.2 installed and I have JAVA_HOME set to jdk 1.7

    I used postgresql-9.3-1103.jdbc41.jar, but  SQL developer didn’t populated the PostgreSQL tab to make the new connection.

    Could you please shed some light on the issue.

    Many thanks.

     

    Regards,

    Thiro

     

  7. Hello Gokhan

    Thanks for this post. Just wanted to add that for JDK 1.8, one would need to use the JDBC42 version of the Postgres JDBC driver.

  8. Tks! Help me a lot

  9. Marcelo Santana says:

    Hi Gakhan,

    I have SQL Developer 4.1 installed and postgresql-9.3-1103.jdbc3.jar, but SQL developer didn’t populated the PostgreSQL the label “Choose database”.

    Inform the remote address but what to do to load the databases?


    They are not listed.

    🙁

    Thank’s for help

     

    Marcelo Santana

    • Marcelo Santana says:

      There is an alternative, performing the modification of the saved connection, through the connections.xml file.

      Step:
      1 – Save the connection to PostgreSQL in SQL Developer to add connection information in connections.xml by filling in the fields;
      2 – open the connections.xml file (~/.sqldeveloper/system4.0.3.16.84/ o.jdeveloper.db.connection.12.2.1.0.42.151001.541/connections.xml)
      3 – find added entry and add the database in line
      ex:
      Old: jdbc:postgresql://host123:5432/
      New: jdbc:postgresql://host123:5432/database
      4 – Close and open SQL Developer to load the information added to the connections.xml file.

  10. Raj Shivraman says:

    Thanks! That really helped me a lot in getting this done. Truly appreciate the helpful instructions.

  11. Hi Gokhan,

    I have SQL Developer 4.1.3.20 installed and postgresql-9.4.1208.jre7.jar, but SQL developer didn’t populated the PostgreSQL the label “Choose database”.

    Inform the remote address but what to do to load the databases?
    The database is PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-11), 64-bit
    They are not listed.

    Thank’s for help

    Livia Souza

  12. some extra contortions are necessary if the PostgreSQL username does not match the database name.

    http://orlygoingthirty.blogspot.com/2016/04/connecting-to-amazon-redshift-or.html

  13. Hi Gokhan,
    We have a PostgreSQL DB built on a cloud platform. And we need to replicate data (under one entire schema) from that PostgreSQL DB to our Oracle DB. What tool/method can be used for that connectivity?

    That is, we’d like to know how to connect a cloud DB to an Oracle DB.

    Thanks in advance for your help!

  14. Great article ! Thanks !

Trackbacks/Pingbacks

  1. Configuring Oracle SQL Developer for PostgreSQL » DbRunas - […] http://www.gokhanatil.com/2014/09/configuring-oracle-sql-developer-for-postgresql.html […]

Leave a Reply

Your email address will not be published. Required fields are marked *