How to generate an Azure Database for PostgreSQL connection string with PowerShell

APPLIES TO: Azure Database for PostgreSQL - Single Server

This article demonstrates how to generate a connection string for an Azure Database for PostgreSQL server. You can use a connection string to connect to an Azure Database for PostgreSQL from many different applications.

Requirements

This article uses the resources created in the following guide as a starting point:

Get the connection string

The Get-AzPostgreSqlConnectionString cmdlet is used to generate a connection string for connecting applications to Azure Database for PostgreSQL. The following example returns the connection string for a PHP client from mydemoserver.

Get-AzPostgreSqlConnectionString -Client PHP -Name mydemoserver -ResourceGroupName myresourcegroup
host=mydemoserver.postgres.database.azure.com port=5432 dbname={your_database} user=myadmin@mydemoserver password={your_password} sslmode=require

Valid values for the Client parameter include:

  • ADO.NET
  • JDBC
  • Node.js
  • PHP
  • Python
  • Ruby
  • WebApp

Next steps