My primary use case for this is for development and experimentation, I have no intent on using it on production servers :)
I normally use migrations for those. On Sun, Dec 13, 2020 at 9:04 PM Ron <ronljohnso...@gmail.com> wrote: > > 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. > >
