On Wed, 2 Feb 2011, Greg Williamson wrote:
It will not overwrite any existing data; if the table has constraints that will prevent duplicates then the entire load will fail if any item fails (it is a single transaction). If the table doesn't have such constraints then duplicate data in the copy file will result in duplicate rows.
Greg, These data originate in highly undisciplined Excel spreadsheets over the past 10+ years. They need a lot of preprossing in emacs and python scripts I've written but there are no primary keys or other constraints until all the data are entered then moved to the actual application tables. I will not be surprised to discover duplicate data because of data-entry errors, but there should not be any duplicates in these permit compliance monitoring results. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
