Dear all,
I am new to PostgreSQL and have just started using it for a few weeks.
I have a (probably very simple) question regarding an execution of a
SQL command which is automatically repeated every period of time. For
example, I want to copy a txt file into a table (e.g. with command
COPY traffic FROM 'C:/TEMP/flow.txt' ) every 5 minutes. The
'flow.txt' file is produced by an external system and updated (by
overwriting it) every 5 minutes. Can anyone let me know how to do it
or where to put the command in PostgreSQL to automate the execution of
the copy command according to time?
Many thanks in advance.
Yos