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 45FF9ADB.4030500@postgresql.org
Whole thread Raw
In response to Re: Default "maximum rows to retrieve" setting  (John DeSoi <desoi@pgedit.com>)
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: jiniusatwork-postgresql@yahoo.com
Date:
Subject: pgadmin binary for Solaris?