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