patternsqlMinor
No way to set maximum retrieved rows in pgadmin query tool
Viewed 0 times
pgadminrowsmaximumretrievedquerywaysettool
Problem
I'm using version 1.16.1, and I can't find a "max(imum) rows" param to tweak. Any help would be appreciated.
Solution
I don't think there is a global parameter to tweak in pgAdmin 1.16.*
As an alternative you can open tables with:
This is also available from the context menu of a table in the object browser.
Once the data grid is open, a "Limit Bar" is available, where you can set a maximum for returned rows.
I would consider it a reasonable feature request to make this "Limit" element available in the "View data options" you get when you open a table with a filter (grid icon with funnel). This could also remember the last setting.
A global setting is a bit of a foot gun. People forget and then wonder why they don't get more rows.
As an alternative you can open tables with:
Tools -> View Data -> View Top 100 rowsThis is also available from the context menu of a table in the object browser.
Once the data grid is open, a "Limit Bar" is available, where you can set a maximum for returned rows.
I would consider it a reasonable feature request to make this "Limit" element available in the "View data options" you get when you open a table with a filter (grid icon with funnel). This could also remember the last setting.
A global setting is a bit of a foot gun. People forget and then wonder why they don't get more rows.
Code Snippets
Tools -> View Data -> View Top 100 rowsContext
StackExchange Database Administrators Q#42384, answer score: 8
Revisions (0)
No revisions yet.