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.
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