Copy Table from Text File; Start at Line Number X Rather than at Beginning of File

Copy Table from Text File; Start at Line Number X Rather than at Beginning of File

Post by johnalex » Wed, 01 Sep 2004 03:21:35


Hi,

I have a text file I need to import into Postgres, v. 7.2. The file
has a header row.

I want to begin the import at the line below the header row. Is this
possible, or will I have to strip the header row from the file prior
to the import? If it is possible, what flag do I use in the COPY
command?

Thanks.