Received: from magus.postgresql.org ([87.238.57.229])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <robjsargent@gmail.com>) id 1TXoMh-0001Zi-19
	for pgsql-sql@postgresql.org; Mon, 12 Nov 2012 07:23:27 +0000
Received: from mail-vc0-f174.google.com ([209.85.220.174])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <robjsargent@gmail.com>) id 1TXoMe-0001eH-1W
	for pgsql-sql@postgresql.org; Mon, 12 Nov 2012 07:23:26 +0000
Received: by mail-vc0-f174.google.com with SMTP id fk26so5805065vcb.19
	for <pgsql-sql@postgresql.org>; Sun, 11 Nov 2012 23:23:22 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:content-type:content-transfer-encoding;
	bh=6ca4OPibXPBp02dH77nQD9Rdg+3SGZ+/gHASDYg4sJg=;
	b=uq1jhh1ZW37nDELQcgV66TV0g2FQ3ey0L+fX7kOMmyivaP2PqEBXdtEY1rw0b0ByVy
	DEv3QxEvOwdNyQEg3h546HChjBPRJORBdojCBkydmosiuF1iE8+mzmRkzY1ufDuOnGYp
	lXouEAGaSiPGH4XPBRjyMRhXCt7IepJ+5UxlIkwPVDveq+lxJbITiMFyBADo9XspA7vg
	15Jnphzw6r6V57eRgaKCREQj8w5ZbU5lfTRDB71Yx4FI6bO5M+fCIT8OKl7NjdrMDL4r
	dYsu+wTJeZ0e+AZX4dIuaMyhtUe9joFg4UepNMV8cgox0izZ/Skaj9clfPBh+8NavTie
	XQvw==
Received: by 10.58.145.161 with SMTP id sv1mr18468221veb.52.1352705002783;
	Sun, 11 Nov 2012 23:23:22 -0800 (PST)
Received: from [192.168.2.11] ([70.49.50.227])
	by mx.google.com with ESMTPS id x4sm6357888vdh.13.2012.11.11.23.23.21
	(version=SSLv3 cipher=OTHER); Sun, 11 Nov 2012 23:23:21 -0800 (PST)
Message-ID: <50A0A3DE.7070701@gmail.com>
Date: Mon, 12 Nov 2012 00:23:10 -0700
From: Rob Sargentg <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:16.0) Gecko/20121028 Thunderbird/16.0.2
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: How to compare two tables in PostgreSQL
References: 
 <CA+MnYCqoDRAQRzJQ2pi4jbZkyDdHtpszc4JH+hFT2TkaE86bxQ@mail.gmail.com>
In-Reply-To: 
 <CA+MnYCqoDRAQRzJQ2pi4jbZkyDdHtpszc4JH+hFT2TkaE86bxQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201211/6
X-Sequence-Number: 36939

On 11/10/2012 08:13 PM, saikiran mothe wrote:
> Hi,
>
> How can i compare two tables in PostgreSQL.
>
> Thanks,
> Sai
Compare their content or their definition?