Home > mailing lists

Re: How to export query results to excel file using psql command in postgresql - Mailing list pgsql-general

From	Pavel Stehule
Subject	Re: How to export query results to excel file using psql command in postgresql
Date	August 13, 2020 17:15:08
Msg-id	CAFj8pRCdEk-JAZw82ZfVfKFWPGcR2nzGbbxWDvjCAHApESX-9g@mail.gmail.com Whole thread Raw
In response to	How to export query results to excel file using psql command in postgresql (Naveen Kumar <naveenmcp@gmail.com>)
List	pgsql-general

čt 13. 8. 2020 v 16:10 odesílatel Naveen Kumar <naveenmcp@gmail.com> napsal:

How to export query results to excel file using psql command in postgresql

Excel can import csv file

so you can

for Postgres 12

\pset format csv

\o path_to_file

select * from ...

or for older postgres

\copy (select * from ...) to path_to_file CSV HEADER

Regards

Pavel

From: Naveen Kumar
Date: 13 August 2020, 17:10:10
Subject: How to export query results to excel file using psql command in postgresql

From: Paul Förster
Date: 13 August 2020, 17:15:21
Subject: Re: How to export query results to excel file using psql command in postgresql