pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <shammat@gmx.net>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
Date: Mon, 20 Mar 2023 17:10:42 +0100
Message-ID: <aaba797d-7d79-b075-8aaf-223ec6fc1bbf@gmx.net> (raw)
In-Reply-To: <CAGA3vBsvSs6ga3UJ2nbj3+FopLAkyukorjSabJH4ez6qe5DSgQ@mail.gmail.com>
References: <CAGA3vBtNLpGdPG=4gdzvD9zoTSz+52JUkfYCsNSi+mv5Yr+GVw@mail.gmail.com>
	<A6F7CC72-F6AC-49B6-8DEC-19787D18D7F5@gmail.com>
	<CAGA3vBsD_xiwuXWua6bceGToc9ZX1fmOfiaDXkw29zfqLhQ=Uw@mail.gmail.com>
	<ac9c17a9-016a-e84b-1ef3-14ce4380f05d@sqlexec.com>
	<CAGA3vBv-BkLgTyf-DRW9DYjnF2=BMuKOpT0Gp7cCD1oWDvSxqw@mail.gmail.com>
	<938034.1679325008@sss.pgh.pa.us>
	<CAGA3vBsvSs6ga3UJ2nbj3+FopLAkyukorjSabJH4ez6qe5DSgQ@mail.gmail.com>

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





view thread (20+ messages)  latest in thread

Message-ID: <aaba797d-7d79-b075-8aaf-223ec6fc1bbf@gmx.net>
Permalink:  ../aaba797d-7d79-b075-8aaf-223ec6fc1bbf@gmx.net/
Also on:    postgresql.org/message-id/aaba797d-7d79-b075-8aaf-223ec6fc1bbf@gmx.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: shammat@gmx.net, pgsql-admin@lists.postgresql.org
  Subject: Re: PostgreSQL equivalents to dbms_metadata.get_ddl & dbms_metadata.get_dependent_ddl
  In-Reply-To: <aaba797d-7d79-b075-8aaf-223ec6fc1bbf@gmx.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox