Thread: Help on an sql

Help on an sql

From
James Lapham
Date:

Hi

 

I’m looking for some help, I’ve just accessed PGAdmin for the 1st time as I need to extract a lot of data from my system. When running an sql , the data output return is always a maximum of 542 lines when it should be in the 1000’s. I’m presuming there’s a setting somewhere to allow more results, if anyone can point me in the right direction I’d be grateful?

 

Regards

 

James Lapham

 

 

 

 

Re: Help on an sql

From
Adrian Klaver
Date:
On 6/29/24 00:22, James Lapham wrote:
> Hi
> 
> I’m looking for some help, I’ve just accessed PGAdmin for the 1^st time 
> as I need to extract a lot of data from my system. When running an sql , 
> the data output return is always a maximum of 542 lines when it should 
> be in the 1000’s. I’m presuming there’s a setting somewhere to allow 
> more results, if anyone can point me in the right direction I’d be grateful?

Per here:

https://www.postgresql.org/list/

This list is for:

"Discussion of development and coordination of the PostgreSQL websites."

You want either:

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

or

https://www.postgresql.org/list/pgsql-general/

> 
> Regards
> 
> James Lapham
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com