From: Richard Huxton <dev@archonet.com>
To: Mohamed ebrahim <mohdebrahim@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Help
Date: Sun, 25 Mar 2001 21:23:22 +0100
Message-ID: <007f01c0b569$740a4ec0$1001a8c0@archonet.com> (raw)
References: <20010325064905.22963.qmail@web1004.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, mohdebrahim@yahoo.com
Subject: Re: Help
In-Reply-To: <007f01c0b569$740a4ec0$1001a8c0@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox