Re: Export as csv

From: "Barrington-Hughes, Alan" <Alan_Barrington-Hughes(at)PremierInc(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Export as csv
Date: 2017-11-01 14:24:30
Message-ID: 1CD98658-417C-4B23-810D-A95105C630D5@premierinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

+1 for tsv and insert statements

Cheers, Alan
--
Alan Barrington-Hughes

On Nov 1, 2017, at 4:00 AM, matshyeq <matshyeq(at)gmail(dot)com<mailto:matshyeq(at)gmail(dot)com>> wrote:

****This email did not originate from the Premier, Inc. network. Use caution when opening attachments or clicking on URLs.*****

.
+1
It would be definitely very welcome feature.
You may consult how is that done in sqldeveloper by Oracle<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.oracle.com_technetwork_developer-2Dtools_sql-2Ddeveloper_overview_index.html&d=DwMFaQ&c=2Nw3fMGo2X8W9N0cgJ8QEE6dJUdSW43Zo0sycqQq3H0&r=JXlHlKf8Hjakso54E_rGKblOv3Fth6Zevxm0R26zlGKmuafRJMMVOJj3dLMEx0vS&m=k8HA5IO0kI01--jqhR8nI4gGqpyK5q9-C4HB0FKtnH4&s=Tf3k3FOd6J39ntlfsOxnRDZWcI2SPT7lM_zPy1Ar4p0&e=> 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(at)sun(dot)ac(dot)za<mailto:jspies(at)sun(dot)ac(dot)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<tel:021-808%204699>
Databestuurder / Data manager Faks: 021-883 3691<tel:021-883%203691>

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<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.sun.ac.za_emaildisclaimer&d=DwMFaQ&c=2Nw3fMGo2X8W9N0cgJ8QEE6dJUdSW43Zo0sycqQq3H0&r=JXlHlKf8Hjakso54E_rGKblOv3Fth6Zevxm0R26zlGKmuafRJMMVOJj3dLMEx0vS&m=k8HA5IO0kI01--jqhR8nI4gGqpyK5q9-C4HB0FKtnH4&s=CDxkt0eju9bcfG-rJToD0Kw179RseTkZoKfN2tm-xLM&e=>

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Johann Spies 2017-11-02 09:35:22 F5 - irritating behaviour
Previous Message Willy-Bas Loos 2017-11-01 11:19:04 Multiple head revisions after git pull (2.0rc1 --> 2.0)