Does this skill support the latest versions of PostgreSQL?

Yes, it specifically provides guidance for PostgreSQL versions 14 through 17, including version-specific feature detection logic.

Why should I use pg_dump as a reference instead of standard documentation?

While documentation is helpful, pg_dump is the official tool used to dump databases; its source code contains the 'ground truth' for how PostgreSQL internals should be queried, especially for complex objects.

Is this skill specific to any programming language?

While it includes examples for Go, the SQL logic and system catalog patterns are universal and can be applied to any language including Python, Node.js, or Java.

Can this skill help with DDL formatting?

Yes, it references how pg_dump handles quoting rules and uses internal functions to generate correct DDL for constraints, indexes, and triggers.

pg_dump Reference

Name: pg_dump Reference
Author: Activer007

byActiver007

データベース管理

Consults the official PostgreSQL pg_dump implementation to provide canonical guidance on system catalog queries and schema extraction.

概要

The pg_dump Reference skill serves as a technical bridge between the official PostgreSQL source code and your development workflow. It provides precise instructions for querying internal system catalogs, handling complex database objects like triggers and constraints, and managing version-specific features across PostgreSQL 14-17. By treating pg_dump as the 'source of truth,' this skill ensures that database introspection and DDL generation logic remain robust, accurate, and aligned with PostgreSQL's internal representation of objects.

主な機能

Maps database objects to specific pg_dump source functions and files
Explains the usage of internal helper functions like pg_get_expr and pg_get_constraintdef
Details object dependency tracking and relationship logic based on pg_depend
Offers guidance on handling version-specific PostgreSQL syntax and features
Provides verified SQL patterns for querying pg_catalog tables
0 GitHub stars

ユースケース

Building or debugging database introspection tools and ORMs
Learning how PostgreSQL represents complex objects like partial indexes and row-level security policies internally
Implementing custom schema migration engines that require exact metadata

概要

主な機能

Maps database objects to specific pg_dump source functions and files
Explains the usage of internal helper functions like pg_get_expr and pg_get_constraintdef
Details object dependency tracking and relationship logic based on pg_depend
Offers guidance on handling version-specific PostgreSQL syntax and features
Provides verified SQL patterns for querying pg_catalog tables
0 GitHub stars

ユースケース

Building or debugging database introspection tools and ORMs
Learning how PostgreSQL represents complex objects like partial indexes and row-level security policies internally
Implementing custom schema migration engines that require exact metadata