Home > mailing lists

Migrate schemas - Mailing list pgsql-general

From	Lorusso Domenico
Subject	Migrate schemas
Date	February 9, 2024 00:18:09
Msg-id	CAJMpnG4=OgE7THL+trmCukC60FLCGdijhrwkcK=MRTOR0s9U8w@mail.gmail.com Whole thread Raw
Responses	Re: Migrate schemas
List	pgsql-general

Hello guys,

I have 4 schemas with cross references (e.g.: a function refers to a rowtype of a table of another schema, or a table invokes a function).

Backup schemas by pgadmin the resulting script doesn't follow the correct order to ensure the object creations.

There is a way to tell postgresql to check the reference at the end of script? Or a way to arrange DDL in the right order?

thanks'

Domenico L.

From: Laurenz Albe
Date: 08 February 2024, 22:23:43
Subject: Re: archive command doesnt work

From: Adrian Klaver
Date: 09 February 2024, 00:31:13
Subject: Re: Migrate schemas