Re: retun cursor - Mailing list pgsql-general

From Stephan Szabo
Subject Re: retun cursor
Date
Msg-id 20020408093629.F76539-100000@megazone23.bigpanda.com
Whole thread Raw
In response to retun cursor  ("Madhavi Daroor" <madhavi@zoniac.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Frank Hilliard
Date:
Subject: Re: PHP, HTML Forms & PostgreSQL
Next
From: Janine Sisk
Date:
Subject: Re: Tcl_CreateSlave error (pg 7.1.2, RH 7.2)