Home Import csv file beginning on specific line number
Reply: 0

Import csv file beginning on specific line number

user531
1#
user531 Published in June 23, 2018, 2:29 am

I want to import a csv file into a table beginning on line 9 of the csv file. How do I specify this condition in postgresql?

The first 8 lines have a bunch of irrelevant text describing the data below. This is a screenshot of the file imported into Excel.

And this is the table in my db I am trying to insert the data into.

CREATE TABLE trader.weather
(
station text NOT NULL,
"timestamp" timestamp with time zone NOT NULL,
temp numeric(6,2),
wind numeric(6,2)
)
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.311982 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO