Re: Save results in CSV

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Kay Khandpur <kkhandpur(at)gmail(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Save results in CSV
Date: 2021-03-04 04:41:07
Message-ID: CAM9w-_mW=Q8uJNmbtFMbWveh=BnDMpEcu-kMZFFH58en0RE6Bg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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"

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Richard Brockie 2021-03-04 04:57:53 Re: pgAdmin 4 v5.0 released
Previous Message Kay Khandpur 2021-03-04 04:38:25 Re: Save results in CSV