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

From Andy Shellam
Subject Default "maximum rows to retrieve" setting
Date
Msg-id 45FD2FF4.3040809@mailnetwork.co.uk
Whole thread Raw
Responses Re: Default "maximum rows to retrieve" setting
List pgadmin-support
Hi,

In the Preferences options, there's an option on the Query tab that says 
"Maximum rows to retrieve."  This is currently set to 100, but I can't 
see how/where it takes effect.

I have a table that's growing an average of 250 rows a day (currently at 
1098 rows.)  If I select the table, and use the toolbar button "view 
data in selected object", it retrieves all rows, with the limit 
drop-down set to "No Limit."

If I open the query editor, and type "SELECT * FROM large_table;" that 
retrieves all rows as well.  I have to manually key "LIMIT 1000" in the 
query, or change the drop-down in the view data dialogue (after all data 
has been downloaded.)

Ideally what I'd like is to set the default rows to retrieve to 1000, so 
it downloads the first 1000 rows when I open the table, and then I can 
choose to retrieve others if I need to.

Thanks

Andy.


pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: pgAgent service problem
Next
From: "Sabin Coanda"
Date:
Subject: Re: pgAgent service problem