pgquarrel
pgquarrel copied to clipboard
eulerto
pgquarrel compares PostgreSQL database schemas (DDL)
table-partition [default true] option allows to ignore table partition and partition index compares which in big projects (where 90% of tables are partitions) boosts compare process speed dramatically (in our...
This adds the ADD/DROP constraint logic for checks. I found you were already querying checks. I'm not sure if this exhaustively works for all check scenarios but for simplistic cases...
This adds support for `GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY` (introduced in PG 10). I'm not sure I got all the queries right (particularly around the sequence...
This doesn't change any default behavior of `run-test.sh`, so it continues to behave identically, but adds some additional configuration that users can opt-in. This makes it possible for me to...
Can we add an option to exclude relation partitions? In our company we have dozens of partitions and the process takes about 10 minutes to compare database as 90% of...
When some tables reference each other through foreign keys it would be good to first issue `CREATE TABLE` statements and then, once all tables had been created, add any constraints/foreign...
**Describe the bug** It appears that functions with differing search paths result in incorrect output due to `buildStringList` being unable to parse a `search_path` with commas. I'm not super familiar...
These filters was useful to me include-table = include table(s) with regex exclude-table = exclude table(s) with regex exclude-column = exclude column(s) of all tables with regex exclude-table-column = exclude...
Would be very interesting if we could compare two schemas, on same server or on separate servers. Two OPTIONS will be needed: source-schema and target-schema.
