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

Answer 1

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