You can always do an insert and add a trigger that checks the key for
existence. If it exists do the update instead.
That way you have one line of code doing both inserts and updates.
The only problem with it is that it looks confusing from an outsiders
perspective, so it would have to be document
[EMAIL PROTECTED] (Paul R) wrote:
> I need some advice.. I am new to PG8 - I am working on the project
> that needs to load data daily to PostgreSQL from the text file.. the
> text file is 40MB comma delimited file with row consisting of 20-30
> fields and couple thousands of rows..
>
> so the data
> I need some advice.. I am new to PG8 - I am working on the project
> that needs to load data daily to PostgreSQL from the text file.. the
> text file is 40MB comma delimited file with row consisting of 20-30
> fields and couple thousands of rows..
>
> so the data needs to be parsed and if the ro
On Fri, 2005-02-18 at 20:34 -0500, Paul R wrote:
> I need some advice.. I am new to PG8 - I am working on the project
> that needs to load data daily to PostgreSQL from the text file.. the
> text file is 40MB comma delimited file with row consisting of 20-30
> fields and couple thousands of rows..
