On Fri, Jun 27, 2008 at 5:08 AM, Yos Sunitiyoso
> 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.
Postgresql doesn't have tools to do that directly. If you are on
Linux or Unix, you can use cron; Windows probably has something
similar to automate tasks.
In response to
pgsql-novice by date
|Next:||From: Bruce Momjian||Date: 2008-06-30 19:52:08|
|Subject: Re: [NOVICE] encoding problems|
|Previous:||From: Yos Sunitiyoso||Date: 2008-06-27 09:08:11|
|Subject: Automatic SQL command execution|