On Sep 19, 2006, at 11:15 AM, Emi Lu wrote:
> Greetings,
>
>
> *Except* copy command, are there other quick ways to load data from
> a csv file into a pgsql table please?
There are several bulk loaders, but I believe they all use COPY
behind the scenes.
If copy isn't an option then your best bet will be many inserts in a
transaction, but that'll be significantly slower. You could cobble
together a loader using perl, DBI and one of the CPAN CSV modules
fairly easily.
(But I can't think of any reason why you wouldn't use copy, so you
must have some constraint you haven't mentioned - can you expand on
why copy isn't an option?)
Cheers,
Steve