Postgres Pro
Downloads
Home   >   mailing lists

Re: Triggers: How to make one that fires at a certain time - Mailing list pgsql-general

From dima
Subject Re: Triggers: How to make one that fires at a certain time
Date
Msg-id 3D6A2F4E.8090807@mail.ru
Whole thread Raw
In response to Triggers: How to make one that fires at a certain time of day?  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
List pgsql-general
Tree view 
Jean-Christian Imbeault wrote:
> I'd like to have a table that generates a row entry everyday at
> midnight. Is there anyway to create a trigger (or something else) that
> would fire at midnight and insert a row into a table?
cron? psql "query"...

pgsql-general by date:

Previous
From: Jean-Christian Imbeault
Date:
Subject: Triggers: How to make one that fires at a certain time of day?
Next
From: Oliver Elphick
Date:
Subject: Re: Triggers: How to make one that fires at a certain