Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements

Поиск
Список
Период
Сортировка
От Rémi Cura
Тема Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements
Дата
Msg-id CAJvUf_upH0ek6aGTBeMCHJjzfqpOcLWN132d5p-ANKwKs3E7Rw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements  (Khangelani Gama <kgama@argility.com>)
Список pgsql-general
Дерево обсуждения
Not sure, but maybe

update foo

set br_desc = bar.br_desc

, br_active = bar.br_active

(rest of columns)

where br_cde = bar.br_cde;


Anyway it seem sto be terribly bad idea to give those kind of names !


Cheers,

Rémi-C

В списке pgsql-general по дате отправления:

Предыдущее
От: Khangelani Gama
Дата:
Сообщение: Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements
Следующее
От: Chris Curvey
Дата:
Сообщение: Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements