Re: Batch processing

>  On 29 Jul 2003 at 10:28, gnotari@linkgroup.it wrote:
>
>  > I'm in the need of something similar to Oracle's batch processing, in
>  > Postgres.
>  > I would like to have something like a queue of "requests" (SQL
selects),
>  > run one by one, so not to overload the server -- every SELECT is
>  > 'intensive'.
>  >
>  > How would you implement such a thing?
>
>  psql databasename < selectfile
>
>  Would that do? You need to prepare the select file beforehand but
something on
>  similar line should work..

This, combined with the 'batch' command, could be a beginning.
Actually, I want to integrate all this with Zope, so I'll probably won't
use psql but python, serialize the results and put them in a table as text
objects.

thanks
Guido