Re: pgAdmin 4 records limit of 2000

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: dudedoe01 <marsalanaq(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pgAdmin 4 records limit of 2000
Date: 2016-09-06 19:26:21
Message-ID: 1a7fedec-b642-3eb6-749a-0e520638e428@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 09/06/2016 10:05 AM, dudedoe01 wrote:
> Hi,
>
> I have pgAdmin 9.4. I can only view 2000 rows of data at a time in pgAdmin 4
> while the previous version 9.3 there was no limit. Is there anyway to remove
> the limit on the rows of data I can see all the data concurrently.
>
> Please provide insights.
>
> Thanks in Advance,
>
> <http://postgresql.nabble.com/file/n5919751/Capture.png>

https://www.pgadmin.org/docs4/dev/query_tool.html?highlight=limit

The Query tool

The Query tool Toolbar

No limit

Use the No limit drop-down listbox to specify how many rows to display
in the output panel.
Select from No limit (the default), 1000 rows, 500 rows, or 100 rows.

>
>
>
> --
> View this message in context: http://postgresql.nabble.com/pgAdmin-4-records-limit-of-2000-tp5919751.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2016-09-06 19:31:42 Re: PostgreSQL Database performance
Previous Message Steve Atkins 2016-09-06 19:18:14 Re: PostgreSQL Database performance