Hi Ric,
You could use a cron job that executes a SQL statement to delete the old
records.
:-)
Regards and best wishes,
Justin Clift
Ric Mañalac wrote:
>
> hello,
>
> how can i make postgres to execute a query automatically during
> scheduled times?
>
> here's my situation. i store records on a table. these records should be
> removed 1 day after they were created.
>
> thanks.
>
> ric
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi