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

From Adrian Klaver
Subject Re: Is there a way to dump schema to files on disk and keep them in sync
Date
Msg-id 94d0857d-fbeb-81d6-e285-f088e5efb472@aklaver.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  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Re: Is there a way to dump schema to files on disk and keep them in sync  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
On 12/12/20 6: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.
> 
> Is there a tool that does this? Is there a tool that will dump the
> schema into separate directories and files like pgadmin does?

pgAdmin does not create directories, it just organizes the contents of 
the system catalogs into GUI elements.

For schema management I would suggest a tool like the one I use 
Sqitch(https://sqitch.org/). It will organize the process of schema 
creation and management.

> 
> Thanks.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Is there a way to dump schema to files on disk and keep them in sync
Next
From: Tomas Vondra
Date:
Subject: Re: Is there a way to dump schema to files on disk and keep them in sync