Re: [SQL] Postgres schema comparison.

From: Stef <svb(at)ucs(dot)co(dot)za>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-ADMIN(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Postgres schema comparison.
Date: 2005-03-07 15:31:55
Message-ID: 20050307173155.285dc2eb@svb.ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

Tom Lane mentioned :
=> > The problem I have with this, is that I have to run the command per table,
=>
=> Why?
=>
=> If the problem is varying order of table declarations, try 8.0's
=> pg_dump.

Yes, this will solve the global schema check, but I will still need to split
it into "per table" dumps , to do "per table" comparisons.

Kind Regards
Stefan

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John DeSoi 2005-03-07 15:32:07 Re: Postgres schema comparison.
Previous Message Stef 2005-03-07 15:22:06 Re: [SQL] Postgres schema comparison.

Browse pgsql-sql by date

  From Date Subject
Next Message John DeSoi 2005-03-07 15:32:07 Re: Postgres schema comparison.
Previous Message Stef 2005-03-07 15:22:06 Re: [SQL] Postgres schema comparison.