Automated CSV upload to PostgreSQL

Question

I would like to ask if it´s possible to update a CSV with daily data (temperature, pressure, humidity, etc.. ) to PostgreSQL as a scheduled task.

I´d like to create a new table every time with format YYYYMMDD which can be uploaded automatically as a scheduled task on PostgreSQL.

I´ve seen there is a function called PGagent which I have installed but not sure about the use.

Many thanks

I´d like to create a new table every time with ... Why? What is the use of having a lot of tables with exactly the same structure? — wildplasser
– wildplasser, Commented Mar 19, 2017 at 15:47
Just to hold the monthly data, but if it´s not possible it will work for me just overwrite each time the same table with the same attributes but changing only time-stamp. Thanks — Georengoku
– Georengoku, Commented Mar 19, 2017 at 16:08
Why not add/append the new data, growing the table with every import? — wildplasser
– wildplasser, Commented Mar 19, 2017 at 16:15
Thanks wildplasser, I think that can be the idea, add new data to the table, but I still need an automated thing/script? that can upload automatically a CSV file to PostgreSQL every day. — Georengoku
– Georengoku, Commented Mar 19, 2017 at 16:21
You can automate that, either with cron(if you happen to live on Unix) or with something like PgAgent. — wildplasser
– wildplasser, Commented Mar 19, 2017 at 16:52

Jendrusk · Accepted Answer · 2017-03-20 12:06:57Z

1

Just write some simple script using copy statement and run it via psql+cron or pgagent.

answered Mar 20, 2017 at 12:06

Jendrusk

8135 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1