This is from the Tutorial for version 6.4 of PostgreSQL.
SET - Set run-time parameters for session
SET variable { TO | = } { 'value' | DEFAULT }
SET TIME ZONE { 'timezone' | LOCAL };
QUERY_LIMIT
Sets the number of rows returned by a query.
Value
Maximum number of rows to return for a query. The default is
to allow an unlimited number of rows.
#
Sets the maximum number of rows returned by a query to #.
DEFAULT
Sets the maximum number of rows returned by a query to be
unlimited.
By default, there is no limit to the number of rows returned by a
query.
On Thu, 29 Apr 1999, Martin Wong wrote:
> Sorry for the previous posting. The following worked.
>
> BTW, this affects just this database or throughout the entire postgresql
> server?
>
> And, how does one reset this variable to max?
>
> Thanks
>
> martin
>
> This works in 6.4.2:
>
> set QUERY_LIMIT TO '10'; or
> set QUERY_LIMIT = '10';
>