Re: Is there a way to dump schema to files on disk and keep them in sync - Mailing list pgsql-general

From Ron
Subject Re: Is there a way to dump schema to files on disk and keep them in sync
Date
Msg-id 6aee220f-2438-5b7e-80e5-d59798581a2e@gmail.com
Whole thread Raw
In response to Is there a way to dump schema to files on disk and keep them in sync  (Tim Uckun <timuckun@gmail.com>)
Responses Re: Is there a way to dump schema to files on disk and keep them in sync
List pgsql-general
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.



pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Is there a way to dump schema to files on disk and keep them in sync
Next
From: Adrian Klaver
Date:
Subject: Re: Is there a way to dump schema to files on disk and keep them in sync