Re: Save results in CSV

Hi Kay,

Previously, the download CSV button used to run the query again. The
behaviour is corrected now.
The "Save results to file" indicates save the query output result. It will
not run the query, and will save whatever is in the grid.

On Thu, Mar 4, 2021 at 6:58 AM Kay Khandpur <kkhandpur(at)gmail(dot)com> wrote:

> I just upgraded to pgAdmin 4 v5.0 from v4.29.
>
> There is change in the default behavior when I save my query results as a
> CSV.
>
> In the earlier version I would include a limit statement in my query to
> test it. Then I would highlight the query without the limit statement,
> click on the download icon and ALL results would download into a CSV and be
> opened by Excel.
>
> In the new version, clicking on the download icon after following the same
> steps gives me only the results from the query with the limit (say 100)
> that I had used for testing. To get full results I have to re-run the query
> without the limit statement, and then click the download icon. This results
> in the CSV being downloaded, but not automatically opened by Excel.
>
> Are there some settings I can change to revert to the earlier behavior? Or
> are there any other workarounds to download results with fewer steps?
>
> Thanks.
>
>

--
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"