Search code examples
postgresqlazureideconnection

How to connect PostgreSQL Azure Cloud Server with SQL Developer?


Does anyone know if there is any chance to connect a PostgreSQL Azure Cloud Server with SQLDeveloper? If someone knows this may you could explain to me how it works. Or if it doesn't work which IDE should I use for it? Thanks for helping me out!


Solution

  • You can connect azure PostgreSQL database using Azure Data Studio. I tried to repro this and below are the steps to connect using ADS.

    • Install Azure Data Studio and Click extensions on ADS and install PostgreSQL.

    enter image description here

    • Click on Connections and in servers, click new connection.

    enter image description here

    • Set Connection type to PostgreSQL and enter the connection details like Server name, username and password. Click connect. enter image description here

    enter image description here

    Azure PostgreSQL DB is connected using Azure Data Studio.

    Reference: MS document Quickstart: Connect and query PostgreSQL - Azure Data Studio | Microsoft Learn