extract ddl to devops pipeline

From: Lorusso Domenico <domenico(dot)l76(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: extract ddl to devops pipeline
Date: 2024-03-06 21:18:13
Message-ID: CAJMpnG6cPc05c2XNg00eeiq2jkxrD+2i=q+WM47QT9kK_hCbcQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello guys,
I need to export the DDL (tables, funcitons views) of some schemas (with
cross references) to load them in a pipeline like DevOps ready.

Problem: export/backup doesn't care about the appropriate sequence of objet
because these stuff will be solved by import phase.

So there is a way to automatically generate DDL in the right order?

I mean, if function Foo reference in input/output definition (also i
declare section?) to table Bar, I've need to create the table before the
function.
And if Bar uses function Lir (in trigger? check? else?), Lir must be create
before Bar.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-03-06 21:22:32 Re: extract ddl to devops pipeline
Previous Message Guyren Howe 2024-03-06 20:57:38 Re: Thoughts on user-defined types for talk at Postgres conference?