Welcome to pglib

pglib is a Python 3.5+ module for working with PostgreSQL databases. It is a C extension that exposes the libpq API. It is designed to be small, fast, and as convenient as possible. It provides both synchronous and asynchronous APIs.

Unlike some libraries, it never modifies the SQL you pass. Parameters are passed using the official libpq protocol for parameters.

• Quick Start
  • Connecting
  • Basic Selecting
  • Parameters
• Asynchronous Quick Start
  • Connecting
  • Selecting
• Building
  • OS/X
  • Linux
  • Windows
• Tips
  • Where X In Parameters
• API
  • pglib
  • Connection
  • ResultSet
  • Row
  • Error
• Data Types
  • Parameter Types
  • Result Types