> 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