Postgres - store collected data from one view into table?

Asked Dec 02 '15 at 15:01

Active Dec 02 '15 at 15:01

Viewed 96 times

VERSION: Postgres 9.3 / PG-Admin 3

I don't know if there is a way to do this or not - but I have created a view that queries for a real-time data collection of one row. It runs a query and gives a result for that time. Here's my goal:

set that query to run every 5 minutes
Every time that query runs I want to store that piece of data into another permanent table. So the view collects the data - the table will store the data.

Each time the view refreshes, I lose the previous record - so that's why I'm trying to store the data into another table.

The reason for the query that collects one row at a time for collecting real-time data - but I need a place to store it so I can have a historical data reference for later.

Is there a way to do this in Postgres? Any tips or ideas are greatly appreciated!!

asked Dec 02 '15 at 15:01

Nicoale

1

Not quite clear. What about `insert into permanent_table select now(),* from a_view`? – Egor Rogov Dec 02 '15 at 16:38
Yes! That got me in the direction I needed to go. Thank you! – Nicoale Dec 02 '15 at 20:42

Postgres - store collected data from one view into table?

0 Answers0