On Fri, 25 Nov 2011, Scott Mead wrote:
Why don't you first load the data into a table (no primary key), then use SQL to find your dups? once loaded: SELECT <primary_key_column>, count(1) from <table> group by 1 having count(1) > 1; At least then, you'll really know what you're in for. You can either script a DELETE or... whatever you want to do, once clean, you can add the PK.
Scott, I'll do this. First I need to find why 2 rows (of 143260) are not in the table after reading the source file. I have those 2 rows somewhat isolated as one's in the third quarter of the file and one in the fourth quarter. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
