commpare 2 tables

From: Ivan <iv(at)psycho(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: commpare 2 tables
Date: 2003-03-05 17:17:36
Message-ID: Pine.LNX.4.44.0303051811140.9420-100000@rex.anfa.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I've 2 temp tables build as this same select , how can i find differences
between this tables, for example : find differ rows by same primary key,
or which rows are in one table but not in second ... ??
Is there same simple way, or i will have to compare this table manualy ?

how do samething like : CREATE OR REPLACE TEMP TABLE name AS ... ?

thx :>
ivan

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Fiche 2003-03-05 17:20:06 Re: What about SELECT INTO in EXECUTE
Previous Message Ivan 2003-03-05 17:10:58 Re: What about SELECT INTO in EXECUTE