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:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
