Overview - Python Connector for PostgreSQL

Overview

Python Connector for PostgreSQL is a connectivity solution for accessing PostgreSQL databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector enables you to establish a direct connection to PostgreSQL from a Python application via TCP/IP, eliminating the need for the database client library. A direct connection increases the speed of data transmission between the application and PostgreSQL database server. It also streamlines the deployment process since you don't have to distribute any client libraries with the application.

Secure communication

The connector supports encrypted communications using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.

Compatibility

• Python versions from 3.7 to 3.12
• PostgreSQL versions:
• PostgreSQL server from 8.0 to 15.0
• Microsoft Azure Database for PostgreSQL
• Amazon RDS for PostgreSQL
• Amazon Aurora
• Google Cloud for PostgreSQL
• Heroku Postgres
• SQLAlchemy
• pandas
• petl

Supported platforms

• Windows 32-bit and 64-bit
• Windows Server 32-bit and 64-bit
• macOS 64-bit and ARM (Apple M1 and M2)
• Linux 64-bit

Note: For details on supported OS versions, check the compatibility page of your Python version.