Message-ID: <007f01c0b569$740a4ec0$1001a8c0@archonet.com>
From: "Richard Huxton" <dev@archonet.com>
To: "Mohamed ebrahim" <mohdebrahim@yahoo.com>, <pgsql-sql@postgresql.org>
References: <20010325064905.22963.qmail@web1004.mail.yahoo.com>
Subject: Re: Help
Date: Sun, 25 Mar 2001 21:23:22 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

From: "Mohamed ebrahim" <mohdebrahim@yahoo.com>

> Hi,
>
>     I am a user postgresql. I want to update a table
> automatically when we reach monthend. i.e i want to
> update some table on 31 of every month automatically
> without any user attention. I want to know how to do
> this. If anyone knows how to do this please mail me. i
> will be ever thankfull to him

I'm presuming that you are on some kind of unix-like system. If so, check
the "cron" system (man cron, man crontab) - use this to run a script at a
set time each month - the script can then update your database.

This can be as simple as placing a script into /etc/cron.monthly/ on some
systems (e.g. Linux Redhat) but in any case is not too complicated.

PS - it is usually easier to do this early on the first day of each month
(every month has a day 1, not all have a day 31).

- Richard Huxton