Skip site navigation (1) Skip section navigation (2)

Re: combining tables

From: Cliff Nieuwenhuis <cliff(at)nieusite(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: combining tables
Date: 2008-10-26 04:59:28
Message-ID: 20081025235928.42951f23@killick (view raw or whole thread)
Lists: pgsql-novice
G. J. Walsh wrote:

> 1 of the 4 tables has the complete range of keys, in this case about
> 1,000. The other 3 tables have data representing most but not all of
> those keys, and in different sets. I want to end up with a new
> 'combined' table which will allow me to immediately 'see' missing data
> from the 3 smaller tables and take the necessary steps to 'fill in the
> blanks'. I realize I would of course have to create that table without
> constrictions other than the primary key.

Do you mean you want to find keys that exist in the 'main' table but
have no match in the other three tables?

Cliff Nieuwenhuis

In response to


pgsql-novice by date

Next:From: G. J. WalshDate: 2008-10-26 05:26:56
Subject: Re: combining tables
Previous:From: G. J. WalshDate: 2008-10-26 01:02:39
Subject: combining tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group