Re: Can COPY skip columns?

On 18/11/04 5:15 pm, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Adam Witney <awitney(at)sghms(dot)ac(dot)uk> writes:
>> Is it possible for the COPY command to read data from a file, but skip
>> specific columns?
>
> Nope. When you get into significant massaging of the input data,
> usually the best bet is to COPY into a temp table that exactly matches
> the format of the data file, and then do your rearrangements using an
> INSERT/SELECT into the final target table.

Ah ok. Can COPY be made to skip the first row then? To avoid the column
headers?

Thanks

adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.