Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article includes links to examples that show how to connect and query with Azure Database for PostgreSQL. It also includes TLS recommendations and extensions that you can use to connect to the server in supported languages.
Quickstarts
| Quickstart | Description |
|---|---|
| Pgadmin | Use pgadmin to connect to the server. It simplifies the creation, maintenance, and use of database objects. |
| psql in Azure Cloud Shell | This article shows how to run psql in Azure Cloud Shell to connect to your server and then run statements to query, insert, update, and delete data in the database. You can run psql if installed on your development environment. |
| Python | This quickstart demonstrates how to use Python to connect to a database and work with database objects to query data. |
| Django with App Service | This tutorial demonstrates how to use Ruby to create a program to connect to a database and work with database objects to query data. |
TLS considerations for database connectivity
All drivers that Microsoft supplies or supports for connecting to databases in your Azure Database for PostgreSQL flexible servers use Transport Layer Security (TLS). No special configuration is necessary, but enforce TLS 1.2 for newly created servers. If you're using TLS 1.0 or 1.1, update the TLS version for your servers. See How to configure TLS.
PostgreSQL extensions
Azure Database for PostgreSQL provides the ability to extend the functionality of your database by using extensions. Extensions bundle multiple related SQL objects together in a single package that you can load or remove from your database by using a single command. After being loaded in the database, extensions function like built-in features.