Re: how to merge a table from another DB

Поиск
Список
Период
Сортировка
От Mike Nolan
Тема Re: how to merge a table from another DB
Дата
Msg-id 200402172016.i1HKGdAI032393@gw.tssi.com
обсуждение исходный текст
Ответ на how to merge a table from another DB  ("Hought, Todd" <Todd.Hought@echostar.com>)
Список pgsql-general
> the forked db can be merged back in to the live one. A change to one
> column of every row in a certain table. How can I update just that field
> in every row of the db without harming the existing data already in that
> table?

Would something like this work?

    UPDATE table1
    set table1.columna = table2.columna
    from table2
    where table1.keyfield = table2.keyfield;
--
Mike Nolan

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: String manipulation
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: how to merge a table from another DB