Re: retun cursor

On Sat, 8 Apr 2000, Madhavi Daroor wrote:

> Hi,
> I followed the steps that you told me. An it worked fine. But I have one
> problem and that is......when I try to fetch all the resords of a table, it
> gives me the folowing error
>
> psqldb=# fetch all from "<unnamed cursor 4>";
> less: not found

The pager for doing multiple page output isn't found. You should be able
to turn it off with
\pset pager
I believe or you could check your PAGER environment variable.

> And please explain to me how I could execute this in java.
I don't know much about the java interface, but I'd guess it's pretty much
the same as sending any other queries.