Thread: pgAdmin 4 records limit of 2000

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>



--
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.

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.klaver@aklaver.com

Hi Adrian,

The query tool toolbar is disabled in my pgAdmin 4. Is there anyway I can
enable it.

<http://postgresql.nabble.com/file/n5919825/Capture.png>



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

On 09/06/2016 12:58 PM, dudedoe01 wrote:
> Hi Adrian,
>
> The query tool toolbar is disabled in my pgAdmin 4. Is there anyway I can
> enable it.

I don't know. I rarely use pgAdmin3 and have only looked at the new
pgAdmin once or twice. I would say you will find a more informed
audience here:

https://www.postgresql.org/list/pgadmin-support/

>
> <http://postgresql.nabble.com/file/n5919825/Capture.png>
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com