On 12/12/20 8:58 PM, Tim Uckun wrote:
> I want to dump my postgres schema to disk in neat directories like
> pgadmin presents. Then I want to be able to edit the files and sync
> changes to the database and ideally if changes were made in the
> database to sync them back to the disk.
That could get really time- and disk-consuming if one of those "edits" was
to convert a column in a large 500M row table from numeric to text (or vice
versa), or add a column to the "middle" of a table.
Tricky to program, too, given all the foreign keys, partitions, etc, etc
that can be part of a table.
> Is there a tool that does this? Is there a tool that will dump the
> schema into separate directories and files like pgadmin does?
--
Angular momentum makes the world go 'round.