Re: Can COPY skip a header line?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can COPY skip a header line?
Date: 2004-11-19 16:03:50
Message-ID: 20041119160350.GF7343@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wouldn't it be easier to have PHP remove the first row?

And PHP has to be there because Apache is sending all the data to it.

Hope this helps,

On Fri, Nov 19, 2004 at 03:43:18PM +0000, Adam Witney wrote:
>
> Following on from my question yesterday... Can COPY then be made to skip a
> header line (the first line of the file say)?
>
> The problem is this... I need to allow a user to upload a data file through
> a web browser (PHP driven). This is then processed and the selected file
> columns mapped to fields in a database, and then the data file uploaded. I
> can do this fine with small files.... But if I get above a 1000 rows it
> takes so long it time out.
>
> 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)
>
> I liked Toms idea to create a temporary table, but I need to be able to get
> rid of the header row then... Is there anyway of avoiding getting PHP
> involved in the file processing?
>
> Any ideas?
>
> Thanks
>
> Adam
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Secrétariat 2004-11-19 16:14:44 Re: PostegreSQL 8.0.0 Beta4 Win32
Previous Message Adam Witney 2004-11-19 16:02:55 Re: Can COPY skip a header line?