Import a CSV file into postgres - skip the first line

Question

How to import a CSV file into postgres and skip the first row (these are just column headers).

I'm trying to:

\COPY products(sight, department) from 'coy.csv' with (FORMAT CSV);

+4

More than five Aug 29 '13 at 15:38

1 answer

bma · Accepted Answer · 2013-08-29T15:44:17+0000

Adding a HEADER row will cause the first row to be the column heading.

 COPY products (sight,department) FROM 'coy.csv' CSV HEADER;