PostgreSQL

Connect Azure PostgreSQL with psql command prompt to query a database

by

To connect to Azure PostgreSQL Server by using psql command prompt, perform the following steps: To avoid below error. Add you local IP address to give access to connect PostgreSQL with your psql command prompt. Start psql cmd on your computer and enter the details. Enter the password to connect Create and connect database.

Create your Azure PostgreSQL service

by

You’ll set up Azure Database for PostgreSQL Sign into the Azure portal. In the portal, select Create a resource from the upper left-hand corner. Select Databases, then select Azure Database for PostgreSQL. You will be presented with the choice of a Single server or Hyperscale. Select Create for the Single server option Use these values … Read more