On Wed, 19 Mar 2008, "Tena Sakai" <[EMAIL PROTECTED]> 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: pg_difftable
Description: Binary data

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to