I'm using version 1.16.1, and I can't find a "max(imum) rows" param to tweak. Any help would be appreciated.
Postgresql – No way to set maximum retrieved rows in pgadmin query tool
pgadminpostgresql
Related Question
- Postgresql – Most efficient way of bulk deleting rows from postgres
- Postgresql – How to speed up PgAdmin III Queries
- Postgresql – Retrieve title from rows with a maximum count in other columns
- Postgresql – How to change pgAdmin 4 to display rows retrieved and runtime
- Postgresql – How to Export Each Row of a Table into Separate Text Files
- Postgresql – remove postgres server from local machine
Best Answer
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.