Copy restricting duplicate entries

kundansonuJ

I need to load files in vertica using copy but i do not want duplicate entries. As unique constraint will not be helpful as it will load data and then i may have to delete duplicate entries from ananlyse_constraints().Other is using insert with bit of logic to check wether entry exist in table. I need some better logic which will restrict duplicate entries.With examples will be very helpful.

Thanks

Kundan

timolin

To clarify:  Are you copying from a text file that contains dupliicate entries?

kundansonuJ

Yes, a csv file.