Postgres Pro
Downloads
Home   >   mailing lists

Re: compare 2 tables in sql - Mailing list pgsql-sql

From Volkan YAZICI
Subject Re: compare 2 tables in sql
Date
Msg-id 87tzj27cpd.fsf@alamut.mobiliz.com.tr
Whole thread Raw
In response to compare 2 tables in sql  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-sql
Tree view 
On Wed, 19 Mar 2008, "Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Is there a sql way to compare (in a diff/cmp sense)
> 2 tables?

You can diff "pg_dump --schema-only" output of the related tables. (I
attached an ad-hoc script once I wrote to use for such stuff.) I don't
know about [php]pgadmin, but (IIRC) EMS products offer that
functionality.


Regards.
Attachment

pgsql-sql by date:

Previous
From: "Tena Sakai"
Date:
Subject: compare 2 tables in sql
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: compare 2 tables in sql