CODEWITHSUNDEEP
linuxdatabasepostgresqlpsql
user3352940
user3352940

Reputation: 33

scheduled query execution in postgresql

I am using postgresql 8.4 on a linux centos. I want to write a query that would be executed every hour for example. is there a way to do it using postgresql alone without writing a shell script and schedule it with a cron job?

Upvotes: 0

Views: 1397

Answers (1)

Frank Heikens
Frank Heikens

Reputation: 127056

You could install pgAgent and schedule a job using pgAdmin.

Offtopic: Version 8.4 is not supported anymore, consider an upgrade to a recent 9.* release.

Upvotes: 1

Related Questions