alt-python-pydbc-pg 1.1.0

pydbc driver for PostgreSQL — wraps psycopg2 (pyformat paramstyle)

alt-python-pydbc-pg

pydbc driver for PostgreSQL via psycopg2.

---

Installation

uv add alt-python-pydbc-pg

Note: psycopg2-binary is installed automatically and works for development and CI. For production deployments, replace it with psycopg2 (compiled against the system libpq). See the psycopg2 installation docs for details.

---

URL format

pydbc:pg://user:password@host:port/dbname

The port defaults to 5432 if omitted.

---

Usage

import pydbc_pg  # registers PgDriver with DriverManager
from pydbc_core import DriverManager

conn = DriverManager.get_connection("pydbc:pg://alice:secret@localhost:5432/mydb")
stmt = conn.create_statement()
rs = stmt.execute_query("SELECT 1 AS n")
print(rs.rows)   # [(1,)]
conn.close()

Parameterised queries

# Positional parameters
stmt = conn.create_statement()
rs = stmt.execute_query("SELECT * FROM users WHERE id = ?", (42,))

# Named parameters
rs = stmt.execute_query("SELECT * FROM users WHERE id = :id", {"id": 42})

Prepared statements

ps = conn.prepare_statement("INSERT INTO users (name, email) VALUES (?, ?)")
ps.execute_update(("Alice", "[e-mail]"))
conn.commit()

---

Paramstyle note

psycopg2 uses pyformat (%s / %(name)s) placeholders internally. pydbc accepts both ? (positional) and :name (named) syntax and translates automatically — you never need to know which style the underlying driver uses.

---

Documentation

• Getting started tutorial
• Core API reference

---

License

MIT