Обсуждение: [SQL] exporting query result

On 05/12/2017 02:14 AM, Günce Kaya wrote:
> Good morning all,
>
> I use COPY to exporting query result but I'm curious If there is any way
> to export query result to a CSV file's different spreadsheets through
> Pgadmin or server?

You can export to CSV using COPY. For pgAdmin see:

https://www.pgadmin.org/docs/pgadmin4/1.x/import_export_data.html?highlight=csv

If this is not what you want then you will need to be more specific
about what you are trying to achieve.

>
> Regards
>
> --
> Gunce Kaya
>


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Günce Kaya schrieb am 12.05.2017 um 17:58:
> 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.

A  CSV file has no sheets (it does not even have a "structure" as it is plain text).

The tool I am maintaining can do you what you want (or at least what I think you want):

It has a built-in command to export data to various formats including ODS or XLSX which you need in order to create
multiple"sheets"
 

The following command
  WbExport -file=data.xlsx -sourceTable=table_one,table_two, table_three;

Creates a single XLSX file with three sheets, one for each table.

You can download it here: http://www.sql-workbench.net/

For details on the WbExport command see here: http://www.sql-workbench.net/manual/command-export.html

Disclosure: I am the author of that tool.

Regards
Thomas