Re: Newbie question - Mailing list pgsql-general

From Dann Corbit
Subject Re: Newbie question
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547055BB1@postal.corporate.connx.com
Whole thread Raw
In response to Newbie question  (Hugo <htakada@gmail.com>)
List pgsql-general
Sure.  Just set up psql with a SQL script containing your task using a
chron job.

The psql utility will accept a command file as a parameter.

PostgreSQL has functions rather than stored procedures, but it works out
about the same.

You could also put a bunch of SQL commands that you want to run in the
file that you feed to psql.

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Hugo
> Sent: Wednesday, May 18, 2005 8:24 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Newbie question
>
> hi,
>
> is it possible to schedule the execution of an sql stored procedure in
> postgress on linux?
>
> thanks
>
> Hugo
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 8: explain analyze is your friend

pgsql-general by date:

Previous
From: Sean Davis
Date:
Subject: Re: Count and Results together
Next
From: Csaba Nagy
Date:
Subject: Re: Newbie question