pgplex/pgschema

📋 What's Changed

• fix: use DROP MATERIALIZED VIEW for materialized dependents during recreate (#415) by @tianzhou in https://github.com/pgplex/pgschema/pull/463
• fix: support CREATE/DROP/ALTER AGGREGATE in diff and dump (#416) by @tianzhou in https://github.com/pgplex/pgschema/pull/464
• fix: preserve schema-qualified functions in RLS policy expressions (#427) by @tianzhou in https://github.com/pgplex/pgschema/pull/465
• fix: pre-drop recreated views before dependent column drops (#444) by @tianzhou in https://github.com/pgplex/pgschema/pull/466
• fix: render policy and constraint expressions with table schema search_path (#449) by @tianzhou in https://github.com/pgplex/pgschema/pull/467
• feat: hint at extension dependency when plan fails with missing object errors (#436) by @tianzhou in https://github.com/pgplex/pgschema/pull/468
• fix: recreate dependent FKs when a referenced unique/PK constraint is replaced (#439) by @tianzhou in https://github.com/pgplex/pgschema/pull/470
• fix: strip double-quotes from extracted sequence name in SERIAL ownership detection by @ayusssmaan in https://github.com/pgplex/pgschema/pull/469
• + 11 more

📋 What's Changed

• feat: add constraints section to .pgschemaignore (#429, #447) by @tianzhou in https://github.com/pgplex/pgschema/pull/452
• fix nix packaging by @vkcku in https://github.com/pgplex/pgschema/pull/440
• feat: add triggers section to .pgschemaignore (#407) by @tianzhou in https://github.com/pgplex/pgschema/pull/453
• fix: order CREATE VIEW after ALTER TABLE ADD COLUMN within a plan (#414) by @PadenZach in https://github.com/pgplex/pgschema/pull/417
• refactor: tidy up #414 view-deferral followups by @tianzhou in https://github.com/pgplex/pgschema/pull/454
• fix: quote mixed-case trigger names and FK referenced column names in… by @ayusssmaan in https://github.com/pgplex/pgschema/pull/451
• fix: complete mixed-case identifier quoting in generated DDL (#451 followup) by @tianzhou in https://github.com/pgplex/pgschema/pull/455
• fix: detect numeric precision/scale changes in column diff (#362) by @tianzhou in https://github.com/pgplex/pgschema/pull/456
• + 6 more

✨ New Contributors

• @vkcku made their first contribution in https://github.com/pgplex/pgschema/pull/440
• @ayusssmaan made their first contribution in https://github.com/pgplex/pgschema/pull/451
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.10.0...v1.11.0

📋 What's Changed

• fix: show error location with SQL context when plan fails by @tianzhou in https://github.com/pgplex/pgschema/pull/394
• fix: table-level CHECK constraints with IS NOT NULL silently omitted from dump (#396) by @tianzhou in https://github.com/pgplex/pgschema/pull/398
• fix: plan fails with schema-qualified references in function bodies (#399) by @tianzhou in https://github.com/pgplex/pgschema/pull/400
• fix: name-typed columns dumped as char[] by @ivgiuliani in https://github.com/pgplex/pgschema/pull/411
• Preserve `UNIQUE NULLS NOT DISTINCT` by @ivgiuliani in https://github.com/pgplex/pgschema/pull/413
• feat: add Nix flake and package by @Rooffeell in https://github.com/pgplex/pgschema/pull/381
• Add support for `UNLOGGED` tables by @ivgiuliani in https://github.com/pgplex/pgschema/pull/424
• refactor: refactor the release workflow's test job to use a GitHub Actions matrix strategy, running PostgreSQL 14-18 tests in parallel instead of sequentially. by @NFUChen in https://github.com/pgplex/pgschema/pull/432
• + 3 more

✨ New Contributors

• @ivgiuliani made their first contribution in https://github.com/pgplex/pgschema/pull/411
• @Rooffeell made their first contribution in https://github.com/pgplex/pgschema/pull/381
• @NFUChen made their first contribution in https://github.com/pgplex/pgschema/pull/432
• @guillaume86 made their first contribution in https://github.com/pgplex/pgschema/pull/441
• @vytautas-karpavicius made their first contribution in https://github.com/pgplex/pgschema/pull/438
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.9.0...v1.10.0

📋 What's Changed

• fix: preserve nested function calls in RLS policy expressions (#377) by @tianzhou in https://github.com/pgplex/pgschema/pull/378
• fix: strip temp schema prefix from GRANT/REVOKE function signatures (#376) by @tianzhou in https://github.com/pgplex/pgschema/pull/379
• fix: skip FK constraint drop when referenced table is dropped with CASCADE (#382) by @tianzhou in https://github.com/pgplex/pgschema/pull/383
• fix: skip constraint drop when DROP COLUMN already removes it by @cysp in https://github.com/pgplex/pgschema/pull/388
• ci: upgrade GitHub Actions toolchain for runner and alpine linux compatibility by @gclove in https://github.com/pgplex/pgschema/pull/387
• fix: preserve INCLUDE columns on CREATE INDEX (#385) by @tianzhou in https://github.com/pgplex/pgschema/pull/390
• fix: support CHECK constraints without columns and NO INHERIT modifier (#386) by @tianzhou in https://github.com/pgplex/pgschema/pull/391
• fix: skip privileges for ignored objects in .pgschemaignore (#392) by @tianzhou in https://github.com/pgplex/pgschema/pull/393

✨ New Contributors

• @cysp made their first contribution in https://github.com/pgplex/pgschema/pull/388
• @gclove made their first contribution in https://github.com/pgplex/pgschema/pull/387
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.8.0...v1.9.0

📋 What's Changed

• fix: support view options (security_invoker, security_barrier) in dump and plan by @tianzhou in https://github.com/pgplex/pgschema/pull/352
• feat: add --sslmode flag and PGSSLMODE env var support by @tianzhou in https://github.com/pgplex/pgschema/pull/353
• fix: strip quotes from type names in view dependency detection by @FFX3 in https://github.com/pgplex/pgschema/pull/337
• fix: support NULLS NOT DISTINCT on unique indexes (#355) by @tianzhou in https://github.com/pgplex/pgschema/pull/356
• fix: handle empty search_path and preserve schema qualifiers in function bodies (#354) by @tianzhou in https://github.com/pgplex/pgschema/pull/357
• fix: preserve schema qualifiers in function/procedure bodies (#354) by @tianzhou in https://github.com/pgplex/pgschema/pull/358
• fix: strip schema qualifiers from custom types in RETURNS TABLE (#360) by @tianzhou in https://github.com/pgplex/pgschema/pull/361
• feat: support PostgreSQL 18 temporal constraints (WITHOUT OVERLAPS / PERIOD) by @kenchan0130 in https://github.com/pgplex/pgschema/pull/365
• + 4 more

✨ New Contributors

• @FFX3 made their first contribution in https://github.com/pgplex/pgschema/pull/337
• @kenchan0130 made their first contribution in https://github.com/pgplex/pgschema/pull/365
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.7.4...v1.8.0

📋 What's Changed

• fix: filter default privileges by role membership to fix Supabase regression (#323) by @tianzhou in https://github.com/pgplex/pgschema/pull/334
• fix: rewrite SET search_path in function definitions for temp schema (#335) by @tianzhou in https://github.com/pgplex/pgschema/pull/336
• fix: use target database user for embedded postgres in plan command (#303) by @tianzhou in https://github.com/pgplex/pgschema/pull/338
• chore: update Claude Code skills for development workflows by @tianzhou in https://github.com/pgplex/pgschema/pull/341
• feat: add support for privileges in .pgschemaignore (#339) by @tianzhou in https://github.com/pgplex/pgschema/pull/340
• feat: add support for trigger UPDATE OF columns (#342) by @tianzhou in https://github.com/pgplex/pgschema/pull/344
• fix: clean up leaked cluster-level roles in TestIgnorePrivileges by @tianzhou in https://github.com/pgplex/pgschema/pull/346
• feat: add support for view reloptions (security_invoker, security_barrier) (#343) by @tianzhou in https://github.com/pgplex/pgschema/pull/347
• + 2 more

📋 What's Changed

• fix: exclude DiffSource interface field from JSON serialization (#305) by @tianzhou in https://github.com/pgplex/pgschema/pull/309
• fix: preserve dependency order for views in multi-file dump (#307) by @tianzhou in https://github.com/pgplex/pgschema/pull/310
• fix: use DROP+CREATE for views with column changes instead of CREATE OR REPLACE (#308) by @tianzhou in https://github.com/pgplex/pgschema/pull/311
• fix: quote camelCase column names in online NOT NULL rewrite DDL (#313) by @tianzhou in https://github.com/pgplex/pgschema/pull/315
• fix: normalize view definitions to strip same-schema qualifiers (#314) by @tianzhou in https://github.com/pgplex/pgschema/pull/316
• fix: scope pg_class joins by relnamespace to prevent cross-schema comment misattribution (#318) by @tianzhou in https://github.com/pgplex/pgschema/pull/319
• fix: quote reserved keywords after schema prefix stripping in function bodies (#320) by @tianzhou in https://github.com/pgplex/pgschema/pull/322
• fix: order REVOKE before GRANT when transitioning between table and column privileges (#324) by @tianzhou in https://github.com/pgplex/pgschema/pull/325
• + 4 more

📋 What's Changed

• fix: preserve typmod for extension types in column type resolution (#295) by @tianzhou in https://github.com/pgplex/pgschema/pull/297
• fix: sort object names in multi-file dump for deterministic include order (#299) by @tianzhou in https://github.com/pgplex/pgschema/pull/301
• fix: defer functions with view dependencies to after view creation (#300) by @tianzhou in https://github.com/pgplex/pgschema/pull/302
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.7.1...v1.7.2

📋 What's Changed

• fix: truncated function signatures in GRANT statements (#275) by @tianzhou in https://github.com/pgplex/pgschema/pull/288
• fix: EXCLUDE constraint incorrectly dumped as regular INDEX (#281) by @tianzhou in https://github.com/pgplex/pgschema/pull/289
• fix: spurious plan changes for column defaults with schema-qualified functions (#283) by @tianzhou in https://github.com/pgplex/pgschema/pull/290
• fix: reserved keyword not quoted in online rewrite DDL (#286) by @tianzhou in https://github.com/pgplex/pgschema/pull/291
• fix: INSTEAD OF triggers on views missing from dump (#287) by @tianzhou in https://github.com/pgplex/pgschema/pull/292
• fix: add connect_timeout and ping timeout to database connections by @tianzhou in https://github.com/pgplex/pgschema/pull/293
• fix: strip current schema qualifier from function/procedure bodies in dump (#252) by @tianzhou in https://github.com/pgplex/pgschema/pull/294
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.7.0...v1.7.1

📋 What's Changed

• fix: multiple statements from the same column by @sam-mosleh in https://github.com/pgplex/pgschema/pull/278
• fix: track altering identities by @sam-mosleh in https://github.com/pgplex/pgschema/pull/282
• Full Changelog: https://github.com/pgplex/pgschema/compare/v1.6.2...v1.7.0

📋 What's Changed

• refactor: convert multi-pass to single-pass in plan module by @tianzhou in https://github.com/pgschema/pgschema/pull/245
• fix: function to function dependency by @tianzhou in https://github.com/pgschema/pgschema/pull/247
• fix: topological sort for modified tables' constraint dependencies by @tianzhou in https://github.com/pgschema/pgschema/pull/249
• fix: skip revoking privileges covered by default privileges (#250) by @tianzhou in https://github.com/pgschema/pgschema/pull/251
• fix: revoke default privilege grants on new tables by @tianzhou in https://github.com/pgschema/pgschema/pull/257
• fix: function dependencies by @mistermoe in https://github.com/pgschema/pgschema/pull/258
• fix: missing parentheses in CREATE POLICY USING clause output by @tianzhou in https://github.com/pgschema/pgschema/pull/260
• fix: domain CHECK constraint ordering with function dependencies by @mistermoe in https://github.com/pgschema/pgschema/pull/261
• + 6 more

✨ New Contributors

• @mistermoe made their first contribution in https://github.com/pgschema/pgschema/pull/258
• @curthasselschwert made their first contribution in https://github.com/pgschema/pgschema/pull/267
• @PadenZach made their first contribution in https://github.com/pgschema/pgschema/pull/274
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.6.1...v1.6.2

📋 What's Changed

• fix: add SearchPath comparison to functionsEqualExceptAttributes by @asonawalla in https://github.com/pgschema/pgschema/pull/235
• fix: include FOR ROLE in ALTER DEFAULT PRIVILEGES DDL by @asonawalla in https://github.com/pgschema/pgschema/pull/236
• refactor: review ir module to enhance code readability by @tianzhou in https://github.com/pgschema/pgschema/pull/237
• feat: add support for column-level GRANT privileges by @asonawalla in https://github.com/pgschema/pgschema/pull/238
• fix: ensure embedded postgres cleanup in TestMain by @asonawalla in https://github.com/pgschema/pgschema/pull/239
• fix: emit REVOKE statements before DROP statements by @asonawalla in https://github.com/pgschema/pgschema/pull/243
• fix: include column comments when adding new columns by @asonawalla in https://github.com/pgschema/pgschema/pull/242
• fix: handle BEGIN ATOMIC syntax in SQL-standard function bodies by @tianzhou in https://github.com/pgschema/pgschema/pull/244
• + 1 more

📋 What's Changed

• feat: add support for FORCE ROW LEVEL SECURITY by @tianzhou in https://github.com/pgschema/pgschema/pull/215
• fix: preserve interval type casts in function parameter defaults (#216) by @tianzhou in https://github.com/pgschema/pgschema/pull/217
• fix: preserve schema qualifiers in column default type casts by @tianzhou in https://github.com/pgschema/pgschema/pull/219
• fix: normalize policy expression schema qualifiers by @tianzhou in https://github.com/pgschema/pgschema/pull/222
• docs: supabase declarative schema vs pgschema by @tianzhou in https://github.com/pgschema/pgschema/pull/223
• fix: normalize table references in policy expressions by @asonawalla in https://github.com/pgschema/pgschema/pull/226
• chore: adjust policy table reference test case by @tianzhou in https://github.com/pgschema/pgschema/pull/228
• fix: defer FK constraints until all table batches are created by @tianzhou in https://github.com/pgschema/pgschema/pull/229
• + 4 more

✨ New Contributors

• @asonawalla made their first contribution in https://github.com/pgschema/pgschema/pull/226
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.5.1...v1.6.0

📋 What's Changed

• fix: support overloaded functions and procedures in dump (#191) by @tianzhou in https://github.com/pgschema/pgschema/pull/192
• fix: generated column on public schema by @tianzhou in https://github.com/pgschema/pgschema/pull/201
• fix: partial index by @tianzhou in https://github.com/pgschema/pgschema/pull/202
• fix: quote policy names in DDL output by @tianzhou in https://github.com/pgschema/pgschema/pull/204
• fix: type topological sort by @tianzhou in https://github.com/pgschema/pgschema/pull/205
• fix: include public in search_path for extension type resolution by @tianzhou in https://github.com/pgschema/pgschema/pull/208
• fix: add USING clause for text-to-enum type conversions by @tianzhou in https://github.com/pgschema/pgschema/pull/209
• Fix index name mutation for identifiers containing dots by @tianzhou in https://github.com/pgschema/pgschema/pull/213
• + 1 more

✨ New Contributors

• @alecthomas made their first contribution in https://github.com/pgschema/pgschema/pull/199
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.5.0...v1.5.1

📋 What's Changed

• fix: default column value function order by @tianzhou in https://github.com/pgschema/pgschema/pull/175
• Minor Update to Claude.md by @Adam-Mustafa in https://github.com/pgschema/pgschema/pull/176
• Add `limit` to missing "smart-quote" Keywords by @Adam-Mustafa in https://github.com/pgschema/pgschema/pull/177
• fix: track LEAKPROOF and SECURITY DEFINER by @tianzhou in https://github.com/pgschema/pgschema/pull/181
• Add list of postgres reserved keywords to "smart-quote" keyword list by @Adam-Mustafa in https://github.com/pgschema/pgschema/pull/178
• chore: refine quotation by @tianzhou in https://github.com/pgschema/pgschema/pull/182
• chore: generated_column test case by @tianzhou in https://github.com/pgschema/pgschema/pull/184
• feat: support PG 18 by @tianzhou in https://github.com/pgschema/pgschema/pull/187
• + 2 more

✨ New Contributors

• @Adam-Mustafa made their first contribution in https://github.com/pgschema/pgschema/pull/176
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.4.3...v1.5.0

📋 What's Changed

• fix: constraint name quoting by @tianzhou in https://github.com/pgschema/pgschema/pull/165
• fix: properly drop temporary NOT NULL constraint by @sam-mosleh in https://github.com/pgschema/pgschema/pull/166
• refactor: consolidate uk test case by @tianzhou in https://github.com/pgschema/pgschema/pull/168
• refactor: consolidate pk test case by @tianzhou in https://github.com/pgschema/pgschema/pull/169
• chore: add a fk test case by @tianzhou in https://github.com/pgschema/pgschema/pull/170
• fix: preserve constraints to ignored tables in multi-file dumps by @tianzhou in https://github.com/pgschema/pgschema/pull/171

✨ New Contributors

• @sam-mosleh made their first contribution in https://github.com/pgschema/pgschema/pull/166
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.4.2...v1.4.3

📋 What's Changed

• chore: consolidate DSN construction by @tianzhou in https://github.com/pgschema/pgschema/pull/142
• fix: non-primitive types qualified by @tianzhou in https://github.com/pgschema/pgschema/pull/145
• fix: extension qualifier by @tianzhou in https://github.com/pgschema/pgschema/pull/146
• Revert "fix: extension qualifier (#146)" by @tianzhou in https://github.com/pgschema/pgschema/pull/147
• fix: type/extension from different schema by @tianzhou in https://github.com/pgschema/pgschema/pull/151
• chore: log sql statement when apply/plan when —debug by @tianzhou in https://github.com/pgschema/pgschema/pull/152
• fix: drop trigger/function order by @tianzhou in https://github.com/pgschema/pgschema/pull/154
• fix: normalize schema-qualified identifiers in SQL strings by @p-c-h-b in https://github.com/pgschema/pgschema/pull/157
• + 6 more

✨ New Contributors

• @p-c-h-b made their first contribution in https://github.com/pgschema/pgschema/pull/157
• @isaacparker0 made their first contribution in https://github.com/pgschema/pgschema/pull/163
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.4.1...v1.4.2

📋 Key Changes

• To cover complex schema, use embedded Postgres database as the default. For certain cases such as #121 #122, allow user to supply an external plan database. See [plan DB](https://www.pgschema.com/cli/plan-db) for more info.
• Fix installation #100 #128

📋 What's Changed

• feat: named constraint by @tianzhou in https://github.com/pgschema/pgschema/pull/79
• fix: index name quotation by @tianzhou in https://github.com/pgschema/pgschema/pull/81
• fix: view logic expr by @tianzhou in https://github.com/pgschema/pgschema/pull/87
• fix: generate_column_not_null by @tianzhou in https://github.com/pgschema/pgschema/pull/88
• fix: view array operator by @tianzhou in https://github.com/pgschema/pgschema/pull/89
• refactor: simiplify formatter by @tianzhou in https://github.com/pgschema/pgschema/pull/90
• chore: do not strip type cast by @tianzhou in https://github.com/pgschema/pgschema/pull/95
• fix: varchar normalization by @tianzhou in https://github.com/pgschema/pgschema/pull/96
• + 29 more

📋 Key Changes

• To cover complex schema, use embedded Postgres database as the default. For certain cases such as #121 #122, allow user to supply an external plan database. See [plan DB](https://www.pgschema.com/cli/plan-db) for more info.
• Fix installation #100 #128

📋 What's Changed

• feat: named constraint by @tianzhou in https://github.com/pgschema/pgschema/pull/79
• fix: index name quotation by @tianzhou in https://github.com/pgschema/pgschema/pull/81
• fix: view logic expr by @tianzhou in https://github.com/pgschema/pgschema/pull/87
• fix: generate_column_not_null by @tianzhou in https://github.com/pgschema/pgschema/pull/88
• fix: view array operator by @tianzhou in https://github.com/pgschema/pgschema/pull/89
• refactor: simiplify formatter by @tianzhou in https://github.com/pgschema/pgschema/pull/90
• chore: do not strip type cast by @tianzhou in https://github.com/pgschema/pgschema/pull/95
• fix: varchar normalization by @tianzhou in https://github.com/pgschema/pgschema/pull/96
• + 29 more

📋 What's Changed

• chore: add deb/rpm by @tianzhou in https://github.com/pgschema/pgschema/pull/62
• feat: support CONSTRAINT TRIGGER by @tianzhou in https://github.com/pgschema/pgschema/pull/63
• feat: trigger old table by @tianzhou in https://github.com/pgschema/pgschema/pull/64
• feat: materialized_view_index by @tianzhou in https://github.com/pgschema/pgschema/pull/68
• chore: correct MATERIALIZED VIEW TYPE by @tianzhou in https://github.com/pgschema/pgschema/pull/69
• refactor: dedup index code by @tianzhou in https://github.com/pgschema/pgschema/pull/70
• feat: procedure mode by @tianzhou in https://github.com/pgschema/pgschema/pull/71
• feat: split materialized view from view by @tianzhou in https://github.com/pgschema/pgschema/pull/72
• + 3 more

📋 What's Changed

• fix: trigger after truncate by @tianzhou in https://github.com/pgschema/pgschema/pull/53
• feat: trigger on ignored table by @tianzhou in https://github.com/pgschema/pgschema/pull/56
• feat: VIEW where NOT NULL by @tianzhou in https://github.com/pgschema/pgschema/pull/57
• fix: generated column PK and NULL handling by @tianzhou in https://github.com/pgschema/pgschema/pull/58
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.2.0...v1.2.1

📋 What's Changed

• fix: PGHOST, PGPORT dotenv by @tianzhou in https://github.com/pgschema/pgschema/pull/41
• fix: trigger when IS NOT DISTINCT FROM by @tianzhou in https://github.com/pgschema/pgschema/pull/42
• feat: GENERATED ALWAYS AS (…) STORED by @tianzhou in https://github.com/pgschema/pgschema/pull/43
• feat: \i directive for folder by @tianzhou in https://github.com/pgschema/pgschema/pull/48
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.1.1...v1.2.0

📋 What's Changed

• fix: handle permission errors for functions and procedures by @tianzhou in https://github.com/pgschema/pgschema/pull/33
• fix: parentheses handling in CHECK constraint normalization by @grachevko in https://github.com/pgschema/pgschema/pull/35
• fix: proc visibility by @tianzhou in https://github.com/pgschema/pgschema/pull/36

✨ New Contributors

• @grachevko made their first contribution in https://github.com/pgschema/pgschema/pull/35
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.1.0...v1.1.1

📋 What's Changed

• feat: coalesce in VIEW by @tianzhou in https://github.com/pgschema/pgschema/pull/21
• fix: constraint multi-column ordering by @screenfluent and @tianzhou in https://github.com/pgschema/pgschema/pull/22
• feat: skip online DDL rewrite if it’s new table by @tianzhou in https://github.com/pgschema/pgschema/pull/26
• feat: dotenv (.env) by @tianzhou in https://github.com/pgschema/pgschema/pull/27
• feat: .pgschemaignore by @tianzhou in https://github.com/pgschema/pgschema/pull/28
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.0.3...v1.1.0

📋 What's Changed

• feat: CREATE TABLE LIKE source_table by @tianzhou in https://github.com/pgschema/pgschema/pull/18

📋 What's Changed

• Add Smart Identifier Quoting for PostgreSQL Compatibility by @screenfluent in https://github.com/pgschema/pgschema/pull/7

✨ New Contributors

• @screenfluent made their first contribution in https://github.com/pgschema/pgschema/pull/7
• Full Changelog: https://github.com/pgschema/pgschema/compare/v1.0.1...v1.0.2

📋 Changes

• Fix non-public schema migration https://github.com/pgschema/pgschema/issues/6

📋 Changes

• Declarative: Define your desired schema state in SQL files
• Schema-based: Compare at the schema level instead of the database level to reconcile schemas across different tenants
• Comprehensive: Support most common Postgres objects under a schema
• Transparent: Show exactly what SQL will be executed before applying changes