Connect and query overview for Azure database for PostgreSQL- Flexible Server
APPLIES TO: Azure Database for PostgreSQL - Flexible Server
The following document includes links to examples showing how to connect and query with Azure Database for PostgreSQL Single Server. This guide also includes TLS recommendations and extension that you can use to connect to the server in supported languages below.
|Pgadmin||You can use pgadmin to connect to the server and 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 use 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 use work with database objects to query data.|
TLS considerations for database connectivity
Transport Layer Security (TLS) is used by all drivers that Microsoft supplies or supports for connecting to databases in Azure Database for PostgreSQL. No special configuration is necessary but do enforce TLS 1.2 for newly created servers. We recommend if you are using TLS 1.0 and 1.1, then you update the TLS version for your servers. See How to configure TLS
PostgreSQL provides the ability to extend the functionality of your database using extensions. Extensions bundle multiple related SQL objects together in a single package that can be loaded or removed from your database with a single command. After being loaded in the database, extensions function like built-in features.
Fore more details, see How to use PostgreSQL extensions on Flexible server.