Suppressing Header records in Copy command

[seanarcher7]

All,

If I receive a file with header and trailer, how can I exclude them while loading using copy command. For ex: below is the file format

Code: Select all

C1|C2
1|A
2|B

Is it possible to exclude C1 and C2 from loading in to the table?

[id10t]

HI!

Copy command has option "SKIP N" where N - numbers of rows to skip.
Vertica has no option to skip a footer.

Example:

Code: Select all

COPY <tbl name> FROM <data src> ... SKIP 1