Re: Can COPY skip a header line?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
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:25:46
Message-ID: 419E1E8A.3060004@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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?

You could write a server side function to do the processing. You could
even use plPHP if that is your preferred language.

Sincerely,

Joshua D. Drake

>
> Any ideas?
>
> Thanks
>
> Adam
>
>

--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment Content-Type Size
jd.vcf text/x-vcard 640 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-11-19 16:35:26 Re: PostegreSQL 8.0.0 Beta4 Win32
Previous Message Secrétariat 2004-11-19 16:14:44 Re: PostegreSQL 8.0.0 Beta4 Win32