Database schema diff

From: Michal Novotny <michal(dot)novotny(at)trustport(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Database schema diff
Date: 2015-10-13 15:48:55
Message-ID: 561D27E7.5010906@trustport.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi guys,

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

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

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

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

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

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

Thanks a lot!
Michal

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Álvaro Hernández Tortosa 2015-10-13 16:00:58 Re: bugs and bug tracking
Previous Message Joshua D. Drake 2015-10-13 15:39:16 Re: bugs and bug tracking