Re: extract ddl to devops pipeline

2024-03-06 Thread Adrian Klaver
On 3/6/24 13:18, Lorusso Domenico wrote: 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

Re: extract ddl to devops pipeline

2024-03-06 Thread Christophe Pettus
> On Mar 6, 2024, at 13:18, Lorusso Domenico wrote: > So there is a way to automatically generate DDL in the right order? Standard pg_dump creates files that are in the proper order, although if you exclusive some tables or schemas from the backup, those might cause errors if references from

extract ddl to devops pipeline

2024-03-06 Thread Lorusso Domenico
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