From: | Jerry LeVan <jerry(dot)levan(at)gmail(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:09:12 |
Message-ID: | DAF8B412-1161-4FA0-80B4-461B424F83D0@gmail.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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2011-09-01 17:30:21 | Re: md5 of table |
Previous Message | Jerry LeVan | 2011-09-01 17:07:08 | How can I merge two tables? |