Re: [SQL] exporting query result - Mailing list pgsql-sql

From Günce Kaya
Subject Re: [SQL] exporting query result
Date
Msg-id CAAV2-mV3y54UXMRCg0WTeG_LtRP9pBk-r-qY2zD4vn_yFwnKtw@mail.gmail.com
Whole thread Raw
In response to Re: [SQL] exporting query result  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Hi again,

Thank you for your advice. It's more clear now. I'll look at this link. 

Regards,

Gunce Kaya


On Fri, 12 May 2017 at 19:07, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 05/12/2017 08:58 AM, Günce Kaya wrote:
> Hello,
>
> Thank you for your advice. But I did not want to ask about using Copy. I
> always use it but my requirement  is if there is anyway to export query
> result to CSV's different sheets.

CSV != spreadsheet. You can export to CSV using COPY or \copy in psql
and then import those into a spreadsheet. If you want something that
creates an xls(x) file directly then that is going to require a third
party software. I use Python for doing stuff like that. Some programs I
use are:

Pandas
http://pandas.pydata.org/pandas-docs/stable/io.html

XlsxWriter
http://xlsxwriter.readthedocs.io/

csvkit
http://csvkit.readthedocs.io/en/1.0.2/

FYI, csvkit is a collection of command line tools, so it just needs
Python to be installed.

>
> Regards,
> Gunce Kaya
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com
--
Gunce Kaya

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [SQL] exporting query result
Next
From: Thomas Kellerer
Date:
Subject: Re: [SQL] exporting query result