Re: chron scripts and pgsql - Mailing list pgsql-general

From Dennis Gearon
Subject Re: chron scripts and pgsql
Date
Msg-id 3E911863.B577EC69@cvc.net
Whole thread Raw
In response to chron scripts and pgsql  (Dennis Gearon <gearond@cvc.net>)
Responses Re: chron scripts and pgsql  (Ken Harris <kharris@lhinfo.com>)
List pgsql-general
OOPS,

    'chron' != 'cron'

There's maybe 'one or two more' than I found before, using 'cron'
instead :-)

Dennis Gearon wrote:
>
> I looked in postgres-general, and VERY little came up about 'chron'.
>
> Can anyone outline what it takes not NON INTERACTIVELY do a query with
> pgsql? So it can be done in a chron script?
>
> I want to check a table to see if there's any rows with 'unapproved' in
> one column and then just call mail to send someone an email to approve
> some listings.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: chron scripts and pgsql
Next
From: Ulli Mueckstein
Date:
Subject: call analyze from stored procedure in C