Re: Database schema diff - Mailing list pgsql-hackers

From Pavel Golub
Subject Re: Database schema diff
Date
Msg-id 1817149854.20151015164405@gf.microolap.com
Whole thread Raw
In response to Database schema diff  (Michal Novotny <michal.novotny@trustport.com>)
List pgsql-hackers
Hello, Michal.

Take a look in MicroOLAP Database Designer for PostgreSQL.

You may use it in such way:
1. Reverse Engineering for existent database
2. Apply some changes
3. Modify database - you will get SQL script with all changes

http://microolap.com/products/database/postgresql-designer/

You wrote:

MN> Hi guys,

MN> I would like to ask you whether is there any tool to be able to compare
MN> database schemas ideally no matter what the column order is or to dump
MN> database table with ascending order of all database columns.

MN> For example, if I have table (called table) in schema A and in schema B
MN> (the time difference between is 1 week) and I would like to verify the
MN> column names/types matches but the order is different, i.e.:

MN> Schema A (2015-10-01) |  Schema B (2015-10-07)
MN>                       |
MN> id int                |  id int
MN> name varchar(64)      |  name varchar(64)
MN> text text             |  description text
MN> description text      |  text text

MN> Is there any tool to compare and (even in case above) return that both
MN> tables match? Something like pgdiff or something?

MN> This should work for all schemas, tables, functions, triggers and all
MN> the schema components?

MN> Also, is there any tool to accept 2 PgSQL dump files (source for
MN> pg_restore) and compare the schemas of both in the way above?

MN> Thanks a lot!
MN> Michal







-- 
With best wishes,Pavel                          mailto:pavel@gf.microolap.com




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: On-demand running query plans using auto_explain and signals
Next
From: Pavel Stehule
Date:
Subject: Re: On-demand running query plans using auto_explain and signals