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.
