Re: Default "maximum rows to retrieve" setting - Mailing list pgadmin-support

From Dave Page
Subject Re: Default "maximum rows to retrieve" setting
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Default "maximum rows to retrieve" setting  (John DeSoi <[email protected]>)
List pgadmin-support
John DeSoi wrote:
> One of the useful things about the frontend/backend protocol
> (http://www.postgresql.org/docs/8.2/interactive/protocol.html) is that
> it provides a way to set a value for the maximum number of rows to
> return. This avoids the major hassle of trying to analyze the query and
> figure out how to add a limit clause. Unfortunately, I don't recall
> seeing a way set this using libpq or EXECUTE.

No, I don't believe there is a way - and I'm not sure you can prepare a
statement with more than one query in it either; certainly thats the
case if using PQexecParams.

Regards, Dave.


pgadmin-support by date:

Previous
From: John DeSoi
Date:
Subject: Re: Default "maximum rows to retrieve" setting
Next
From: [email protected]
Date:
Subject: pgadmin binary for Solaris?