pg-dump-reference

Reference pg_dump to understand system catalog queries and schema extraction patterns for pgschema implementation.

• Tool for querying PostgreSQL system catalogs
• Reference for schema extraction patterns
• Canonical source for system catalog queries
• Guide to object representation and dependencies

• Queries system catalogs like pg_class, pg_constraint
• Uses pg_get_expr, pg_get_constraintdef, etc. for expression parsing
• Handles version-specific features (14-18)
• Tracks object dependencies via pg_depend
• Provides accurate DDL formatting patterns
• Supports complex object types (triggers, policies, views)
• Uses internal functions for deprecation and expression parsing

1. 1.Identify the schema object type (table, index, trigger, etc.)
2. 2.Find corresponding pg_dump function (e.g., getTables(), getTriggers())
3. 3.Analyze system catalog queries and join logic
4. 4.Adapt queries to pgschema using pgx and IR structures
5. 5.Handle version differences and NULLs in output