Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A2E572E0039 for ; Wed, 19 Mar 2008 16:20:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28437-05 for ; Wed, 19 Mar 2008 16:20:05 -0300 (ADT) Received: from mx3.hub.org (mx3.hub.org [206.223.169.73]) by postgresql.org (Postfix) with ESMTP id C20F82E002F for ; Wed, 19 Mar 2008 16:20:05 -0300 (ADT) X-Greylist: delayed 00:12:37.744753 by SQLgrey-1.7.5 Received: from mailserver.ttmail.com (unknown [88.255.235.9]) by mx3.hub.org (Postfix) with ESMTP id 0C4D9380AE7 for ; Wed, 19 Mar 2008 16:20:04 -0300 (ADT) Received: from STT1EXF07.TTHMC.LOCAL ([192.168.19.142]) by mailserver.ttmail.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 19 Mar 2008 21:07:11 +0200 Received: from alamut.mobiliz.com.tr ([88.230.58.90]) by STT1EXF07.TTHMC.LOCAL with Microsoft SMTPSVC(6.0.3790.1830); Wed, 19 Mar 2008 21:07:11 +0200 Received: from (unknown [88.230.58.90]) by AVGW-TTMAIL-1.ttmail.com with smtp id 2b40_85b23edc_f5e7_11dc_b021_00142217b48c; Wed, 19 Mar 2008 21:06:07 +0200 From: Volkan YAZICI To: "Tena Sakai" Cc: pgsql-sql@postgresql.org Subject: Re: compare 2 tables in sql References: Date: Wed, 19 Mar 2008 21:09:34 +0200 In-Reply-To: (Tena Sakai's message of "Wed, 19 Mar 2008 10:56:27 -0700") Message-ID: <87tzj27cpd.fsf@alamut.mobiliz.com.tr> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.0.60 (gnu/linux) MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" X-NAI-Spam-Rules: 2 Rules triggered BAYES_00=-2.5, HAS_X_HELO=0 X-OriginalArrivalTime: 19 Mar 2008 19:07:11.0552 (UTC) FILETIME=[6F7C9400:01C889F4] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/124 X-Sequence-Number: 30452 --=-=-= On Wed, 19 Mar 2008, "Tena Sakai" 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. --=-=-= Content-Type: application/octet-stream Content-Disposition: attachment; filename=pg_difftable Content-Transfer-Encoding: base64 IyEvYmluL3NoCgpQR19EVU1QPSIvdXNyL2Jpbi9wZ19kdW1wIgpESUZGPSIvdXNyL2Jpbi9kaWZm IC11IgoKaWYgWyAkIyAtbHQgNCBdOyB0aGVuCiAgICBlY2hvICJVc2FnZTogJDAgPERCTkFNRS0x PiA8VEFCTEUtMT4gPERCTkFNRS0yPiA8VEFCTEUtMj4gWzxQRy1EVU1QLUFSR1M+IC4uLl0iCiAg ICBleGl0IDEKZmkKCkRCTkFNRTE9JDE7IHNoaWZ0ClRBQkxFMT0kMTsgc2hpZnQKREJOQU1FMj0k MTsgc2hpZnQKVEFCTEUyPSQxOyBzaGlmdApQR19EVU1QX0FSR1M9JEAKCkRVTVAxPWBta3RlbXBg CkRVTVAyPWBta3RlbXBgCgpjbGVhcl90ZW1wX2ZpbGVzKCkKewogICAgcm0gLWYgJERVTVAxICRE VU1QMgp9Cgp0cmFwICJjbGVhcl90ZW1wX2ZpbGVzIiBBQlJUIElOVCBRVUlUIFRFUk0KCmR1bXBf dGFibGUoKQp7CiAgICAkUEdfRFVNUCAkUEdfRFVNUF9BUkdTIC0tc2NoZW1hLW9ubHkgLS10YWJs ZSAkMSAkMiBcCiAgICB8IGdyZXAgLXYgIl4tLSIgXAogICAgfCBncmVwICIuIiBcCiAgICA+JDMK fQoKZWNobyAiUnVubmluZyBwZ19kdW1wIG92ZXIgc3BlY2lmaWVkIGRhdGFiYXNlcy4uLiIKZHVt cF90YWJsZSAkVEFCTEUxICREQk5BTUUxICREVU1QMSAmJiBcCmR1bXBfdGFibGUgJFRBQkxFMiAk REJOQU1FMiAkRFVNUDIKClJFVFZBTD0kPwppZiBbICRSRVRWQUwgLW5lIDAgXTsgdGhlbgogICAg Y2xlYXJfdGVtcF9maWxlcwogICAgZXhpdCAkUkVUVkFMCmZpCgplY2hvICIke0RVTVAxfTogRHVt cCBvZiAnJFRBQkxFMScgaW4gJyREQk5BTUUxJy4iCmVjaG8gIiR7RFVNUDJ9OiBEdW1wIG9mICck VEFCTEUyJyBpbiAnJERCTkFNRTInLiIKZWNobwoKJERJRkYgJERVTVAxICREVU1QMgpSRVRWQUw9 JD8KCmNsZWFyX3RlbXBfZmlsZXMKZXhpdCAkUkVUVkFM --=-=-=--