Re: Postgres restore help

Поиск
Список
Период
Сортировка
От Alessandro Gagliardi
Тема Re: Postgres restore help
Дата
Msg-id CAAB3BBJhqtK2ioWhKuHEwjB1jShUOdnEWmRe5VK3XroeGxeLuw@mail.gmail.com
обсуждение исходный текст
Ответ на Postgres restore help  (Piyush Lenka <lenka.piyush@gmail.com>)
Ответы Re: Postgres restore help
Список pgsql-novice
Дерево обсуждения
I would recommend restoring the table to a temporary table and then using something like:
INSERT INTO main_table SELECT temp_table.* FROM temp_table JOIN main_table USING (pk) WHERE main_table.pk IS NULL
Someone else here might have a more efficient way of phrasing that insert statement (I'm still fairly new to the concept of anti-joins). But I think something like this should work for you.

-Alessandro

On Tue, Feb 28, 2012 at 7:34 AM, Piyush Lenka <lenka.piyush@gmail.com> wrote:
Hi,
I m trying to restore only data from a backup file.but i hav some primary key that already exists in the table.
I want to restore non duplicate data only.
Please Help.

Thanks And Regards 
Piyush

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