Can COPY update or skip existing records?
| От | Glenn Gillen |
|---|---|
| Тема | Can COPY update or skip existing records? |
| Дата | |
| Msg-id | 69b2ac8a0809300516t3495c25y2d6a5e00f2c3377c@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Can COPY update or skip existing records?
Re: Can COPY update or skip existing records? Re: Can COPY update or skip existing records? |
| Список | pgsql-sql |
Hey all, I've got a table with a unique constraint across a few fields which I need to regularly import a batch of data into. Is there a way to do it with COPY without getting conflicts on the unique contraint? I have no was of being certain that some of the data I'm trying to load isn't in the table already. Ideally I'd like it to operate like MySQL's on_duplicate_key_update option, but for now I'll suffice with just ignoring existing rows and proceeding with everything else. Thanks, -- Glenn
В списке pgsql-sql по дате отправления: