How can I merge two tables?

From: Jerry LeVan <levanj(at)me(dot)com>
To: "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org>
Subject: How can I merge two tables?
Date: 2011-09-01 17:07:08
Message-ID: C9E22F85-AF26-4DA5-950C-B00B2A581B55@me.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have tables on my various computers that looks like:

Table "public.registrations"
Column | Type | Modifiers | Storage | Description
----------+------+-----------+----------+-------------
software | text | | extended |
id | text | | extended |
value | text | | extended |
location | text | | extended |
Indexes:
"registrations_software_idx" btree (software) CLUSTER
Has OIDs: yes

I keep registration numbers for software and login/passwords for
various organizations, etc…

As time goes by the tables on the various computers get out of
sync.

Is there an elegant way I can get all of the differences (uniquely)
merged into a single table?

Thanks

Jerry

Browse pgsql-general by date

  From Date Subject
Next Message Jerry LeVan 2011-09-01 17:09:12 How can I merge two tables?
Previous Message Scott Marlowe 2011-09-01 16:59:54 Re: strange table disk sizes