Re: Can COPY skip columns? - Mailing list pgsql-general

From Tom Lane
Subject Re: Can COPY skip columns?
Date
Msg-id 17862.1100798138@sss.pgh.pa.us
Whole thread Raw
In response to Can COPY skip columns?  (Adam Witney <awitney@sghms.ac.uk>)
Responses Re: Can COPY skip columns?
Re: Can COPY skip columns?
List pgsql-general
Adam Witney <awitney@sghms.ac.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.

            regards, tom lane

pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: Re: Can COPY skip columns?
Next
From: Richard_D_Levine@raytheon.com
Date:
Subject: Re: Certifications in military environment