Re: Save results in CSV

Thanks Aditya!

So it looks like I got used to a feature that was actually a bug. 😆

Any suggestions on how to automatically open the csv file when it
downloads, as it did before? Or is it the intended behavior to not open the
csv?

On Wed, Mar 3, 2021, 20:28 Aditya Toshniwal <
aditya(dot)toshniwal(at)enterprisedb(dot)com> wrote:

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