As Oracle users many of us are familiar with Oracle SQL Developer. But when we move to PostgreSQL we use PgAdmin as a GUI client to connect to PostgreSQL database.
If our use case is simple, soon we will start missing SQL Developer as it was better compared to PgAdmin. Good news is with SQL Developer 4.0.1.14 we can connect to PostgreSQL database.
Though it will not give you complete Oracle kind of experience it is worth giving a try if you are used to SQL Developer.
Following are the steps to configure Oracle SQL Developer with PostgreSQL Server.
1. Download PostgreSQL JDBC driver from the following link.
https://jdbc.postgresql.org/download.html
2. Open Oracle SQL Developer.
3. Goto Tools->Preferences as shown below.
4. Goto Database->Third Party JDBC Drivers as shown below.
5. Click on Add Entry and Navigate to the folder where you have downloaded the JDBC driver as part of step #1.
6. Click OK.
7. Now you will be able to create connections to PostgreSQL database using the new tab shown in the connection window as shown below.
