Oracle SQL Developer and PostgreSQL

Question

I am trying to connect to a PostgreSQL 9.1 database using Oracle SQL Developer 3.0.04, but so far I have no success.

Firstly, if I add a third-party driver by settings, when adding a new connection there is no tab for PostgreSQL (it works fine for MySQL, though). I am using the JDBC4 driver version 9.1, but I tried JDBC3 of the same version and still get the same.

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

Finally, I connected the import connection from the XML file (contents below), but it only displays my schemas and does not show my tables inside them.

So my question is: Does Orable SQL Developer support PostgreSQL joins? Is there any other way to display tables in ObjectViewer?

<?xml version = '1.0' encoding = 'UTF-8'?> <References xmlns="http://xmlns.oracle.com/adf/jndi"> <Reference name="Lumea" className="oracle.jdeveloper.db.adapter.DatabaseProvider" credentialStoreKey="Lumea" xmlns=""> <Factory className="oracle.jdeveloper.db.adapter.DatabaseProviderFactory"/> <RefAddresses> <StringRefAddr addrType="user"> <Contents>lumea</Contents> </StringRefAddr> <StringRefAddr addrType="subtype"> <Contents>thirdParty</Contents> </StringRefAddr> <StringRefAddr addrType="customUrl"> <Contents>jdbc:postgresql://localhost:5432/versates</Contents> </StringRefAddr> <StringRefAddr addrType="SavePassword"> <Contents>true</Contents> </StringRefAddr> <StringRefAddr addrType="password"> <Contents>myencryptedpass</Contents> </StringRefAddr> <StringRefAddr addrType="driver"> <Contents>org.postgresql.Driver</Contents> </StringRefAddr> <StringRefAddr addrType="DeployPassword"> <Contents>true</Contents> </StringRefAddr> </RefAddresses> </Reference> </References> 

Answer 1

Oracle SQL Developer 4.0.1.14 probably supports PostgreSQL connections.

• download the JDBC driver for Postgres ( http://jdbc.postgresql.org/download.html )
• in SQL Developer, go to Tools → Preferences , Database → Third Party JDBC Drivers and add the jar file (see http://www.oracle.com/technetwork/products/migration/jdbc-migration-1923524.html for a step-by-step example)
• now just create a new Database Connection and select the PostgreSQL tab instead of Oracle

Edit

If you have a different username and database name, you should indicate in the host name: hostname/database? (don't forget ? ) or hostname:port/database? .

(thanks @kinkajou and @ Kloe2378231; more info on https://stackoverflow.com/a/12588/ ... ).

Answer 2

I just downloaded SQL Developer 4.0 for OS X (10.9), it just quit beta. I also downloaded the latest JGBC Postgres jar . In the early bird I decided to install it (the same method as other third-party db drivers in SQL Dev), and he accepted it. Whenever I click "new connection", there is now a tab for Postgres ... and clicking on it shows a panel that asks for information about connecting to the database.

The answer to this question has changed, regardless of whether it is supported or not, it works. There is a “select database” button that, when clicked, gives you a drop-down list populated with available postgres databases. You create a connection, open it, and list the schemas in this database. Most postgres commands seem to work, although there are no psql commands (\ list, etc.).

Those who need one tool to connect to multiple database kernels can now use SQL Developer.

Answer 3

Oracle SQL Developer does not support connections to PostgreSQL. Use pgAdmin to connect to PostgreSQL, you can get it from the following URL http://www.pgadmin.org/download/windows.php

Answer 4

I was able to connect to postgres using SQL Developer. I downloaded the postgres jdbc driver and saved it in a folder. I launched SQL Developer -> Tools -> Settings -> Search -> JDBC. I defined the postgres jdbc driver for the database and Data Modeler (optional).

This is a trick. When creating a new connection, specify Hostname, for example localhost / crm? where crm is the name of the database. Check the connection, work fine.

Answer 5

I got a list of databases to fill out by placing my username in the Username field (without password) and clicking on "Select database". It does not work with an empty user field, I can only connect to my user database.

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