How can I merge two tables?

Поиск
Список
Период
Сортировка
От Jerry LeVan
Тема How can I merge two tables?
Дата
Msg-id C9E22F85-AF26-4DA5-950C-B00B2A581B55@me.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Memory leak somewhere at PQconnectdb?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pgfoundry.org is not accessible