How to skip first several lines when importing CSV from Postgresql?
<p>I was trying to import a CSV file to my Postgresql with the frist 8 lines skipped and start from the 9th line. My codes below works to read from the second line and treat the first line as header: </p>

<pre><code>    create table report(
            id integer,
            name character(3),
            orders integer,
            shipments float

            );

COPY report 
FROM 'C:\Users\sample.csv' DELIMITER ',' CSV HEADER;
</code></pre>

<p>Now how to improve this code to read from the 9th line.
Thank you!</p>

<p><a href="http://i.stack.imgur.com/ESWx8.png" rel="nofollow">CSV details</a></p>