3 ms·
Slightly related: I recently needed to compare several large databases for schema differences. The output from `pg_dump` isn't very diff-friendly at all, so I b
by orf 3y ago
Slightly related: I recently needed to compare several large databases for schema differences. The output from `pg_dump` isn't very diff-friendly at all, so I built this[1]. It outputs schemas in JSON or text, and ensures a stable sort ordering.
It also optionally masks index and constraint names, which might be auto-generated and not relevant to the comparison.
1. https://github.com/orf/diffable-sql https://github.com/orf/diffable-sql