Copy data from one table to another, where some records might already be present

Поиск
Список
Период
Сортировка
От o.blomqvist@secomintl.com (Otto Blomqvist)
Тема Copy data from one table to another, where some records might already be present
Дата
Msg-id c501cb7d.0408100727.70b85c7e@posting.google.com
обсуждение исходный текст
Список pgsql-general
Hello !

I have two tables with identical schema. I want to copy all data from
Table A to Table B, but table B might already have some of table A:s
data (each record is identified using record_numbers). I would suspect
this can be accomlished using a 2 stage query, first performing a join
of some kind and then the copying. But I have little to no clue on how
to make it happen.

Any ideas ?

Thanks a lot !

/Otto Blomqvist

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

Предыдущее
От: "Igor Kryltsov"
Дата:
Сообщение: Postgres update with self join
Следующее
От: Raphael Bauduin
Дата:
Сообщение: hostory tables with a generic function?