I am using version 9.1 and have a large number of files to insert. I am trying to use a simple COPY FROM command but have a couple questions. 1. There are a small number of instances where there are duplicate records that are being caught by the primary key (as it is supposed to do). However, the duplicate records are artifacts of a recording system and can be ignored. I would like to be able to simply skip the duplicate or UPDATE the table with the duplicate… Anything that allows the COPY FROM to proceed while adding only one of the duplicate records to the table. 2. SInce I have several hundred files to perform a COPY FROM on, I'd like to automate the import in some way… sort of a, grab all files in the directory approach: COPY newtable FROM '/directory_of_files/*' WITH CSV HEADER DELIMITER AS ',' NULL AS 'NA'; Is this possible? Thanks in advance -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
