Re: Can COPY skip a header line?

> can do this fine with small files.... But if I get above a 1000 rows it
> takes so long it time out.

    PHP is slow, but not *that* slow, you have a problem somewhere !

> I can upload a 10,000 row equivalent file using COPY from psql in 2
> seconds,
> so the time is down to the PHP processing (really all it does is send
> itto
> pg_put_Line)

    If you read the whole file in memory, the server will kick your script (I
think the default limit is 8 megabytes or something)...

    So, I'd advise reading the file line by line using fgets() (dunno how it
is spelled in php), and just skip the first line, and pg_put_line() the
rest. This way you just use memory for one line at a time. ALso you can
echo (and flush) messages like 'XX lines inserted...' to the user while it
crunches.

    If you're really stuck, and have command execution privileges, why not
system() a command line like "awk -blah your file | psql copy to your
table", or even launch it as a background process ?