View all result rows immediately when executing script

[ghost]

Currently when I execute a query I see the first 200 result rows. Many times I would like to see all rows immediately. I then have to execute the query twice, once for the first 200 rows and then for all rows using a separate button.

I don't want to change the default number of rows, just being able to select to retreive 200 from case to case without multiple button presses or time loss.

[serge-rider]

I don't see how can be solved in UI.
Some tables have too many rows so it can't be done as default behavior. Now You need to click just one extra button (fetch all rows) - how can this be done easier?

[ghost]

It does not need to be easier, it is just that some queries (especially nested queries that take a long time to retreive any result at all) will take twice the time in the end allthough I wanted all rows from beginning. The ability to choose 200 or all rows directly would cut time in half for thoose when needed to retreive all rows. If pushing all rows from the beginnning may casue a crash then I am willing to take the risk (after all the current warning when pressing the current button is good enough guard against this).

[serge-rider]

Ok. But how do you see this in UI?
Extra execute action?

[ghost]

It could be a separate execute button or a switch setting like the commit button in the toolbar.

[serge-rider]

Select All Rows command will be added in the next version.

[gavenkoa]

Ctrl+Alt+Shift+A or right click menu: Execute => Select all rows.

[popovserhii]

I accidentally click "No" in "Do you want to fetch all rows" popup and now don't know how to change this behaviour. Does anybody know where these default settings persist or how to restore the default behaviour of this popup?

[ks-2097]

@popovserhii I have exactly the same issue. Can't get the original behaviour back. Now the button jsut doesn't do anything.
Did you solv it?

[uslss]

it could be changed in Preferences

[ks-2097]

Awesome thanks so much!

[popovserhii]

@uslss Great! Exactly what I was looking for.

[bricsi22]

Thanks for adding the feature it's really useful :)

[stevleibelt]

Finally the solution from @uslss answered my search question "show total row count of sql statement like in pgAdmin".
Thank you very much, I hope my written down search term will help someone in the future, at least my future me :-).

[Git-happiness]

I want to be able to see only the rows updated/inserted after an SQL script run. I can't figure out if this is the same issue. Only thing I get after running a script is the "rows affected" count. I want to see the actual rows.