Thread: Export as csv
Please allow us options to specify the format of the exported data. Example: In pgadmin3 I can select a xml-field and export it without quotes and header to a valid xml-file. I cannot do that in pgadmin4. Also the possibility to export tsv-files and determine the quotes and other separators is just not available. Regards Johann -- Johann Spies Telefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheidvan hierdie epos. http://www.sun.ac.za/emaildisclaimer
+1
It would be definitely very welcome feature.
You may consult how is that done in sqldeveloper by Oracle for a good reference (csv, tsv, custom-separated, html, excel, sql statements etc... file or clipboard; quotes, no quotes, custom quotes, header, no header - pretty much everything is well thought through there, well maybe except 3 screens to go through)
Thank you,
Kind Regards
~Maciek
On 1 November 2017 at 07:40, Johann Spies <jspies@sun.ac.za> wrote:
Please allow us options to specify the format of the exported data.
Example: In pgadmin3 I can select a xml-field and export it without
quotes and header to a valid xml-file. I cannot do that in pgadmin4.
Also the possibility to export tsv-files and determine the quotes and
other separators is just not available.
Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.
The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer
+1 for tsv and insert statements
Cheers, Alan
--
Alan Barrington-Hughes
--
Alan Barrington-Hughes
On Nov 1, 2017, at 4:00 AM, matshyeq <matshyeq@gmail.com> wrote:****This email did not originate from the Premier, Inc. network. Use caution when opening attachments or clicking on URLs.*****
.+1It would be definitely very welcome feature.You may consult how is that done in sqldeveloper by Oracle for a good reference (csv, tsv, custom-separated, html, excel, sql statements etc... file or clipboard; quotes, no quotes, custom quotes, header, no header - pretty much everything is well thought through there, well maybe except 3 screens to go through)Thank you,Kind Regards~MaciekOn 1 November 2017 at 07:40, Johann Spies <jspies@sun.ac.za> wrote:Please allow us options to specify the format of the exported data.
Example: In pgadmin3 I can select a xml-field and export it without
quotes and header to a valid xml-file. I cannot do that in pgadmin4.
Also the possibility to export tsv-files and determine the quotes and
other separators is just not available.
Regards
Johann
--
Johann Spies Telefoon: 021-808 4699
Databestuurder / Data manager Faks: 021-883 3691
Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.
The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer