Installation 

  pip install psycopg2

Quick Start 

  import psycopg2

# Basic usage — see official docs for full API
# https://pypi.org/project/psycopg2/

When to Use

Choose psycopg2 when it fits your project requirements. Compare alternatives in the Libraries hub and specialized tracks.

Production Tips

  1. Pin versions in requirements.txt or poetry.lock
  2. Scan with pip-audit for known CVEs
  3. Read the official documentation for API changes between major versions