Subject: Re: [SQL] exporting query result
To: =?UTF-8?Q?G=c3=bcnce_Kaya?= <guncekaya14@gmail.com>,
 pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
References: 
 <CAAV2-mWJfp9iqpDn8pA11ofGc4RgDVKbUAwuHhXo95j=ooMULg@mail.gmail.com>
 <4498cd4b-95b7-c4f5-add4-b6555267296a@aklaver.com>
 <CAAV2-mV_JLu5rqchgbZUALqHj3YfWGDcU8VpkTcES_YuwinhRQ@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <3d7d9782-0123-6d28-a661-a008ba3024e9@aklaver.com>
Date: Fri, 12 May 2017 09:07:19 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.1.0
MIME-Version: 1.0
In-Reply-To: 
 <CAAV2-mV_JLu5rqchgbZUALqHj3YfWGDcU8VpkTcES_YuwinhRQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin