Murugan G wrote:
Hello,If anybody tried, please let me know how to run a postgresQL function/procedure thro crontab in Linux ES 4.0
$ psql --help This is psql 8.1.0, the PostgreSQL interactive terminal. ...... -c COMMAND run only single command (SQL or internal) and exit ...... So just put a proper invocation of psql in cron, eg something like:0 * * * * /path/to/binary/psql -U foo -h yourhost.com -c "select bar()" dbname 1> /dev/null
Gr, Koen
