On 18/11/04 5:15 pm, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote: > Adam Witney <awitney@xxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
