Organizational Research By

Surprising Reserch Topic

oracle sql developer and postgresql

oracle sql developer and postgresql  using -'sql,oracle,postgresql,oracle-sqldeveloper'

I'm trying to connect to a PostgreSQL 9.1 database using Oracle SQL Developer 3.0.04, but I'm not having any success so far.

First, if I add a third party driver on preferences, when adding a new connection there's no tab for PostgreSQL (it works fine for MySQL though). I'm using a JDBC4 version 9.1 driver, but I tried a JDBC3 of the same version and still get the same thing.

Second, there's nothing like manual configuration tab when adding a new connection. The closest is the Advanced option on Oracle tab, where I can provide a custom URL, but it fails because complains about the selected Driver (of course).

Finally, I got connected importing a connection from an XML file (contents below), but it displays only my schemas and doesn't show my tables inside them.

So, my question is: does Orable SQL Developer support PostgreSQL connections? Is there any other way to have my tables being displayed in the ObjectViewer?

<?xml version = '1.0' encoding = 'UTF-8'?>
<References xmlns="">
    <Reference name="Lumea" className="oracle.jdeveloper.db.adapter.DatabaseProvider" credentialStoreKey="Lumea" xmlns="">
        <Factory className="oracle.jdeveloper.db.adapter.DatabaseProviderFactory"/>
            <StringRefAddr addrType="user">
            <StringRefAddr addrType="subtype">
            <StringRefAddr addrType="customUrl">
            <StringRefAddr addrType="SavePassword">
            <StringRefAddr addrType="password">
            <StringRefAddr addrType="driver">
            <StringRefAddr addrType="DeployPassword">


asked Oct 7, 2015 by sumit_jaiswalmca
0 votes

Related Hot Questions

6 Answers

0 votes

Oracle SQL Developer surely does support connections to PostgreSQL.

answered Oct 7, 2015 by sameer rathore
0 votes

I've just downloaded SQL Developer 4.0 for OS X (10.9), it just got out of beta. I also downloaded the latest Postgres JDBC jar. On a lark I decided to install it (same method as other third party db drivers in SQL Dev), and it accepted it. Whenever I click "new connection", there is a tab now for Postgres... and clicking it shows a panel that asks for the database connection details.

The answer to this question has changed, whether or not it is supported, it seems to work. There is a "choose database" button, that if clicked, gives you a dropdown list filled with available postgres databases. You create the connection, open it, and it lists the schemas in that database. Most postgres commands seem to work, though no psql commands (\list, etc).

Those who need a single tool to connect to multiple database engines can now use SQL Developer.

answered Oct 7, 2015 by sameer rathore
0 votes

Francs is right, SQL Developer does not support PostgreSQL (and I personally doubt that it ever will)

Apart from pgAdmin there are several other SQL tools that are free and support PostgreSQL (including JDBC based tools).

A list of tools is available in the Postgres wiki:

Update 2014-04-23

History has proven me wrong: as of 4.x SQL Developer does allow connecting to Postgres. It's a bit complicated to connect to a database that has a different name than the login user, but it does work.

answered Oct 7, 2015 by akasati02
0 votes

Oracle SQL Developer doesn't support connections to PostgreSQL. Use pgAdmin to connect to PostgreSQL instead, you can get it from the following URL

answered Oct 7, 2015 by patelnikul321
0 votes

I managed to connect to postgres with SQL Developer. I downloaded postgres jdbc driver and saved it in a folder. I run SQL Developer -> Tools -> Preferences -> Search -> JDBC I defined postgres jdbc driver for the Database and Data Modeler (optional).

This is the trick. When creating new connection define Hostname like localhost/crm? where crm is the database name. Test the connection, works fine.

answered Oct 7, 2015 by ashish singh
0 votes

I got the list of databases to populate by putting my username in the Username field (no password) and clicking "Choose Database". Doesn't work with a blank Username field, I can only connect to my user database that way.

(This was with SQL Developer,, and postgresql-9.3-1100.jdbc41.jar, FWIW.)

answered Oct 7, 2015 by akasati02