| From: | Kay Khandpur <kkhandpur(at)gmail(dot)com> |
|---|---|
| To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
| Subject: | Save results in CSV |
| Date: | 2021-03-04 01:28:13 |
| Message-ID: | CAJih1P_NgMQuJ45iqwnJQafBdVdNksi0s_CWxA3nFKiC=HbORQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aditya Toshniwal | 2021-03-04 04:27:27 | Re: Save results in CSV |
| Previous Message | Jackie Culver | 2021-03-03 19:07:55 | Help installing on Mac |