From: Joe Conway <jconway2@home.com>
To: Mohamed ebrahim <mohdebrahim@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Re: Help
Date: Sun, 25 Mar 2001 12:16:33 -0800
Message-ID: <00eb01c0b568$7caf3fa0$0205a8c0@jecw2k1> (raw)
References: <20010325064905.22963.qmail@web1004.mail.yahoo.com>
> 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
Probably the easiest way to do this is to write a script and run it from
cron. For example, if your update query is in a file called
$HOME/bin/monthend.sql:
insert into mymonthendtable(f1, f2, f3)
values(123,'03/31/2001',12345.67);
your script (call it $HOME/bin/monthend.sh) might look like:
#!/bin/sh
psql -U postgres mydatabasename < $HOME/bin/monthend.sql
then run (see "man 5 crontab" for more on cron)
crontab -e
and add an entry like
# run at 2:15 AM on the 30th of every month
15 2 30 * * $HOME/bin/monthend.sh
Hope this helps,
Joe
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: jconway2@home.com, mohdebrahim@yahoo.com
Subject: Re: Help
In-Reply-To: <00eb01c0b568$7caf3fa0$0205a8c0@jecw2k1>
* 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