richard coleman schrieb am 20.03.2023 um 16:48: > My use case is copying and maintaining the same tables in Oracle and > PostgreSQL as well as detecting and applying DDL changes between the > two systems. We are using Liquibase as a schema migration tool which allows us to specify a single "changelog" (using their XML format) that can be applied to Oracle and Postgres alike. So we never need to "compare" definitions, we just run the changelog script to update the database schema. Some differences in e.g. available data types can be dealt with using Liquibase's properties or if everything else fails using different changesets for Postgres and Oracle (which is typically only needed for views and procedural code). Of course it might not be feasible to re-structure your existing infrastructure for schema migrations to use a completely different approach. Thomas
