On 12/13/20 10:03 AM, Benedict Holland wrote:
You want Alembic and an afternoon of python writing. You just described an ORM.
In other words out of the frying pan and into the fire.
On Sun, Dec 13, 2020, 12:53 PM Tomas Vondra <[email protected] <mailto:[email protected]>> wrote:On 12/13/20 6:34 PM, Adrian Klaver wrote: > 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/ <https://sqitch.org/>). It will organize the process of schema > creation and management. > Yeah, that was my thought too. Or maybe look at the other schema versioning tools available - we have a list on the wiki: https://wiki.postgresql.org/wiki/Change_management_tools_and_techniques <https://wiki.postgresql.org/wiki/Change_management_tools_and_techniques> I'm sure it's incomplete, but it's helpful nevertheless. regards-- Tomas VondraEnterpriseDB: http://www.enterprisedb.com <http://www.enterprisedb.com> The Enterprise PostgreSQL Company
-- Adrian Klaver [email protected]
