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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Naveen Kumar <naveenmcp(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to export query results to excel file using psql command in postgresql
Date: 2020-08-13 14:15:08
Message-ID: CAFj8pRCdEk-JAZw82ZfVfKFWPGcR2nzGbbxWDvjCAHApESX-9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

čt 13. 8. 2020 v 16:10 odesílatel Naveen Kumar <naveenmcp(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2020-08-13 14:15:21 Re: How to export query results to excel file using psql command in postgresql
Previous Message Naveen Kumar 2020-08-13 14:10:10 How to export query results to excel file using psql command in postgresql