Re: PGadmin4

voir https://www.openscg.com/bigsql/pgadmin3/index.jsp/ Salutations PAscal chef du projet SQLeo Vieux DBA Oracle en cours de conversion à Postgres -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: Data grid: fetching/scrolling data on user demand

1000 first rows are available in less than zone second. See query with limit 1000. Monitoring memory usage or PG_stat_activity shows that all the data is fetched. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: Data grid: fetching/scrolling data on user demand

Pgadmin doesn't have to Wait for all the data, As he should only load/fetch the first 1000 rows. Loading all the data in memory will not be possible for big datasets. This is a design error at my point of view. PAscal SQLeo projection manager -- Sent from: http://www.postgresql-archive.org

Re: Data grid: fetching/scrolling data on user demand

How long does it take in your environnment to fetch the 1000 first records from select * from information_schema.columns a,information_schema.columns b -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Re: No commit nor Rollback button

Hi Murtuza, I found those options for switching between autocommit mode and manual mode. What I suggest here is to add one button for commit and one button for rollback, they would be green and red in manual transaction mode they would be greyed in autocommit mode. A more advanced behavior in

Re: Data grid: fetching/scrolling data on user demand

maybe this behavior is related to fetching records using a server-side cursor ? https://wiki.postgresql.org/wiki/Using_psycopg2_with_PostgreSQL#Fetch_Records_using_a_Server-Side_Cursor I met the same problem using pgjdbc with Oracle SQL developer as descibed here https://stackoverflow.com/questio

Re: Data grid: fetching/scrolling data on user demand

Sorry, why is *select * from information_schema.columns a,information_schema.columns b * on a newly created db is never ending ? when *select * from information_schema.columns a,information_schema.columns b limit 1000* takes less than one second ? Is pgadmin4 really fetching only the 1000 first

Re: No commit nor Rollback button

Maybe after 20 years, it is time to switch tool default from autocommit to commit/rollback ... to have a chance to be compared with Oracle SQL developer or others PAscal SQLeo projet manager -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

Data grid: fetching/scrolling data on user demand

Hello, Data grid is populated without any limit by default, it could be a problem with very big datasets ... To avoid this, it is possible to limit the number of rows retrieved, but that limit is fixed, even if user tryes to scroll more data ... Is scrolling data on demand supported ? Thanks in

sort data by column with one click

Is there a way to sort data by clicking on the column ? -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html

No commit nor Rollback button

Hello, Most of RDBMS users don't want to use autocommit mode expecting to have a change to Rollback in case of problem. Most of database GUI have Commit/ Rollback buttons (greyed in autocommit mode, enabled in non autocommit mode). Is there a chance to see thoses buttons (using preferences or ot

Re: I'd like a lightweight alternative to pgAdmin4 ?

try SQLeo hosted at sourceforge and not in the GUI list PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html