Access to PostgreSQL

What This Book Will Cover

PostgreSQL is the most standards-compliant open-source database, with no licensing limits at any scale. It's the best choice for organizations that want enterprise-grade features without enterprise-grade costs — but it has the steepest learning curve for Access developers.

This book bridges that gap with a complete, step-by-step migration guide specifically written for people coming from Access. Covers the PostgreSQL-specific concepts that trip up Access developers, with practical solutions for every common issue.

Planned Contents

• PostgreSQL installation and pgAdmin setup
• Key PostgreSQL concepts Access developers need to understand (schemas, roles, case sensitivity)
• Migration using Python (psycopg2, SQLAlchemy)
• Data type mapping: Access to PostgreSQL
• PostgreSQL SQL dialect — what's different from Access
• ODBC setup (psqlODBC driver) for Access front-end
• Sequences vs. AutoNumber vs. IDENTITY
• EXPLAIN ANALYZE — understanding query performance
• Indexes, constraints, and triggers for Access workloads
• JSON and array types — features you didn't know you needed
• Backup and recovery with pg_dump and pg_restore