How do I check for duplicate in table buffered mode? Do I have to do a 'COPY TO' a temp table before I check? It seems troublesome.

This table buffering is really killing my time. Can someone please comment?