Re: Save results in CSV

Thanks!

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

> Hi,
>
> On Thu, Mar 4, 2021 at 10:08 AM Kay Khandpur <kkhandpur(at)gmail(dot)com> wrote:
>
>> 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?
>>
> Opening a file automatically after download is a browser feature. Since
> pgAdmin 5.0 has its own container now, it is not opening it.
> However, you can log the feature request for the team to look into it.
> https://redmine.postgresql.org/projects/pgadmin4/issues/new
>
>>
>> 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"
>>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>