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

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Naveen Kumar <naveenmcp(at)gmail(dot)com>, 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:38
Message-ID: 6d4ea5f4-309f-64d4-eb2c-daa7ac25ab19@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/13/20 7:10 AM, Naveen Kumar wrote:
> How to export query results to excel file using psql command in postgresql

You can't. You can export to CSV that you could then import into Excel.

See:

https://www.postgresql.org/docs/12/app-psql.html

\copy

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2020-08-13 14:19:22 Re: Bytea Example
Previous Message Paul Förster 2020-08-13 14:15:21 Re: How to export query results to excel file using psql command in postgresql