Re: Bulk data insertion

Jonathan Daugherty <jdaugherty(at)commandprompt(dot)com> writes:
> The problem is that I don't want to spend a lot of time and memory
> building such a query (in C). I would like to know if there is a way to
> take this huge chunk of data and get it into the database in a less
> memory-intensive way. I suppose I could use COPY to put the data into a
> table with triggers that would do the checks on the data, but it seems
> inelegant and I'd like to know if there's a better way.

Actually I'd say that is the elegant way. SQL is fundamentally a
set-oriented (table-oriented) language, and forcing it to do things in
an array fashion is just misusing the tool.

regards, tom lane