Supported Entities Overview

This page provides a comprehensive overview of PostgreSQL entities supported by pgdelta, organized by operation type.

Support Status Legend

• ✅ Supported: Full implementation with comprehensive test coverage
• ❌ Not Supported: Not yet implemented, may be planned for future release
• 🚫 Not Applicable: Operation doesn't apply to this entity type
• 🔄 Partial: Limited implementation, see entity details below

Entity Support Matrix

Entity	CREATE	DROP	ALTER	REPLACE	Notes
Schemas	✅	✅	❌	🚫	Basic schema lifecycle
Tables	✅	✅	✅	🚫	Full table support with columns
Constraints	✅	✅	🔄	🚫	All constraint types
Indexes	✅	✅	❌	🚫	All index types and methods
Views	✅	✅	❌	✅	Basic view support
Materialized Views	✅	✅	❌	✅	Created with NO DATA
Functions	✅	✅	❌	✅	All function types via pg_get_functiondef
Triggers	✅	✅	❌	❌	All trigger types via pg_get_triggerdef
Sequences	✅	✅	✅	🚫	Sequence support with OWNED BY
Types	✅	✅	✅	🚫	Enum, composite, and domain types
Policies	✅	✅	✅	🚫	Row Level Security policies
Comments	❌	❌	❌	🚫
Roles	❌	❌	❌	🚫
Grants	❌	❌	🚫	🚫
Default Privileges	🚫	🚫	❌	🚫

Contributing

To contribute support for new entity features: 1. Review the Contributing Guide 2. Follow the Adding New Entities guide 3. Ensure comprehensive test coverage with real PostgreSQL 4. Maintain roundtrip fidelity

The project prioritizes correctness and completeness over speed of implementation.