extract ddl to devops pipeline - Mailing list pgsql-general

From Lorusso Domenico
Subject extract ddl to devops pipeline
Date
Msg-id CAJMpnG6cPc05c2XNg00eeiq2jkxrD+2i=q+WM47QT9kK_hCbcQ@mail.gmail.com
Whole thread Raw
Responses Re: extract ddl to devops pipeline  (Christophe Pettus <xof@thebuild.com>)
Re: extract ddl to devops pipeline  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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.

pgsql-general by date:

Previous
From: Guyren Howe
Date:
Subject: Re: Thoughts on user-defined types for talk at Postgres conference?
Next
From: Christophe Pettus
Date:
Subject: Re: extract ddl to devops pipeline