pg_dump Reference

The 'pg_dump Reference' skill provides guidance for implementing and debugging pgschema features that involve extracting schema information from PostgreSQL databases. As the canonical PostgreSQL schema dumping tool, pg_dump serves as a reference implementation for correctly querying PostgreSQL system catalogs. This skill aids developers in understanding and utilizing pg_dump’s methods for extracting schema-related data, ensuring compatibility with different PostgreSQL versions and handling various schema object types.

Main features include a detailed workflow for identifying schema objects, finding relevant pg_dump functions, analyzing system catalog queries, and handling special cases such as version compatibility and NULL handling. The skill also outlines how to adapt these approaches to the pgschema codebase, with a focus on Go/pgx integration for database introspection. This ensures developers can implement robust, version-aware schema querying solutions within their applications, adhering to best practices for system catalog queries and DDL formatting.

This skill is primarily useful for developers working with PostgreSQL database introspection, those adding support for new schema objects, and anyone debugging or enhancing system catalog queries. It is particularly beneficial for those managing PostgreSQL schema extraction in systems using pgschema, making it a vital tool for ensuring correctness in schema handling and supporting PostgreSQL features across versions 14-18.