[GENERAL] inserting only new rows from csv file

2008-10-01 Thread Seb
Hi, I've seen some approaches to this problem, but I suspect there are better ways. A csv file is produced nightly, with the same table structure as a table in a PostgreSQL database. The file grows over time as new records are added every day. However, the rows in the file may not be sorted

Re: [GENERAL] inserting only new rows from csv file

2008-10-01 Thread Scott Marlowe
On Wed, Oct 1, 2008 at 3:16 PM, Seb [EMAIL PROTECTED] wrote: Hi, I've seen some approaches to this problem, but I suspect there are better ways. A csv file is produced nightly, with the same table structure as a table in a PostgreSQL database. The file grows over time as new records are

Re: [GENERAL] inserting only new rows from csv file

2008-10-01 Thread Harvey, Allan AC
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe Sent: Thursday, 2 October 2008 7:39 AM To: Seb Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] inserting only new rows from csv file On Wed, Oct 1, 2008 at 3:16 PM, Seb [EMAIL