Peter Neu wrote:
Thanks. This script looks good. :o)
How do I call it once a day with a cron job on my linux box?
Put the script in a file (e.g. expiry_script.sql) then add to your crontab:
/path/to/psql -U -d -f /path/to/expiry_script.sql -q
See man psql, man 5 crontab for more details.
Peter Neu wrote:
Hello,
I have 2 tables:
In one I log the user name of a web site user like this:
Name Access time
"makost0001" " 2007-04-19 15:09:19"
"makost0001" " 2007-04-19 15:09:19"
In the other I have the user name his group and the expiry date of his
account.
Name
Hello,
I have 2 tables:
In one I log the user name of a web site user like this:
Name Access time
"makost0001" " 2007-04-19 15:09:19"
"makost0001" " 2007-04-19 15:09:19"
In the other I have the user name his group and the expiry date of his
account.
Name Group
