Support Comments #5
Description
I’d like to propose adding full comment support to dbdiff. Although several forks have experimented with this with Migra, the functionality has never landed in the main source. There are a few reasons to consider it: PostGraphile’s smart comments and pg_graphql both rely on Postgres comments to shape API behavior.
Postgres allows comments on nearly every kind of DDL object, so we’d aim to cover all relevant areas. Handling updates correctly would also mean accounting for cascading deletes and regenerations when objects change.
I’ve explored approaches to this before and am ready to open a PR once I finish the implementation. Before starting, I’d like to open the discussion and hear feedback on requirements, edge cases, or potential pitfalls. Thanks in advance for your thoughts.