Sobre o Python Connector for PostgreSQL

Acesse servidores de banco de dados PostgreSQL e serviços de banco de dados gerenciados a partir de aplicativos Python para executar operações de criação, leitura, atualização e exclusão em dados armazenados.

Python Connector for PostgreSQL is a reliable connectivity solution for accessing PostgreSQL database servers and managed database services from Python applications to perform create, read, update, and delete operations on stored data. The solution fully implements the Python DB API 2.0 specification and is distributed as a wheel package for Windows, macOS, and Linux.

Python Connector for PostgreSQL Features

  • Direct Connection - The solution enables you to establish a direct connection to a PostgreSQL database server through TCP/IP, eliminating the need for the database client library. A direct connection increases the speed of data transmission between a Python application and PostgreSQL server.
  • High Performance - The connector supports a direct connection to PostgreSQL through TCP/IP without the database client library. It also lets you submit multiple update statements to the database for processing as a batch to improve execution time.
  • Fast Deployment - If your Python application must be deployed on multiple user workstations, you don't have to supply the database client library for every user since this connector supports a direct connection.
  • Secure Communication - The connector supports encrypted communication between a PostgreSQL database server and Python application using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.
  • Platform Support - The Python connector is available for Windows 32-bit and 64-bit, macOS 64-bit, and Linux 64-bit.
  • Unicode-Compliant Connector - The Unicode-compliant connector lets you retrieve and update multilingual data, regardless of its character encoding (Chinese, Cyrillic, Hebrew, and more) in any language environment.
  • Data Types Support - The connector supports all PostgreSQL and Python data types. It offers additional options to control data type mapping between the PostgreSQL data types and Python data types.