How can I merge two tables? - Mailing list pgsql-general

From Jerry LeVan
Subject How can I merge two tables?
Date
Msg-id DAF8B412-1161-4FA0-80B4-461B424F83D0@gmail.com
Whole thread Raw
Responses Re: How can I merge two tables?
Re: How can I merge two tables?
Re: How can I merge two tables?
List 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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: strange table disk sizes
Next
From: Scott Marlowe
Date:
Subject: Re: md5 of table