How can I merge two tables?

Поиск
Список
Период
Сортировка
От Jerry LeVan
Тема How can I merge two tables?
Дата
Msg-id DAF8B412-1161-4FA0-80B4-461B424F83D0@gmail.com
обсуждение исходный текст
Ответы Re: How can I merge two tables?
Re: How can I merge two tables?
Re: How can I merge two tables?
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: strange table disk sizes
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: md5 of table