org
Subject: Re: [SQL] compare 2 tables in sql
On Wed, Mar 19, 2008 at 1:56 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Is there a sql way to compare (in a diff/cmp sense)
> 2 tables? For example,
SELECT * FROM foo
EXCEPT
SELECT * FROM moo;
--
Jonah H. Harris, Sr. Softwar
pgsql-sql@postgresql.org
Subject: Re: [SQL] compare 2 tables in sql
On Thu, Mar 20, 2008 at 1:44 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Just a postscript. It is important to check
> both ways. Because (sometimes) vice versa is
> not necessarily true. Case in point below:
On Thu, Mar 20, 2008 at 1:44 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Just a postscript. It is important to check
> both ways. Because (sometimes) vice versa is
> not necessarily true. Case in point below:
Yes, I'm well aware of that. Still, you should UNION the result of
both exceptions
Fantastic! Many thanks.
Regards,
Tena Sakai
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jonah H. Harris
Sent: Wed 3/19/2008 3:39 PM
To: Tena Sakai
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] compare 2 tables in sql
On Wed, Mar 19, 2008 at 1:56 PM, Tena Sakai <[EM
On Wed, Mar 19, 2008 at 1:56 PM, Tena Sakai <[EMAIL PROTECTED]> wrote:
> Is there a sql way to compare (in a diff/cmp sense)
> 2 tables? For example,
SELECT * FROM foo
EXCEPT
SELECT * FROM moo;
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 73
On 2008-03-19 10:56, Tena Sakai wrote:
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
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
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
