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 > > >

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 record

[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 the