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