compare 2 tables in sql

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: compare 2 tables in sql
Date: 2008-03-19 17:56:27
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C0378F138@egcrc-ex01.egcrc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Everybody,

Is there a sql way to compare (in a diff/cmp sense)
2 tables? For example,

create table foo as
[select bla bla bla];

create table moo as
[select bla bla bla];

How would I go about knowing foo and moo are identical
(or not)? Any pointer would be appreciated.

Tena

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Crews 2008-03-19 19:02:25 Date and filling issues
Previous Message D'Arcy J.M. Cain 2008-03-19 16:37:42 Re: Create on insert a unique random number