Обсуждение: How to export query results to excel file using psql command in postgresql

Hi Naveen,

> On 13. Aug, 2020, at 16:10, Naveen Kumar <naveenmcp@gmail.com> wrote:
>
> How to export query results to excel file using psql command in postgresql

use the "copy" command along with its CSV output setting. Then open the CSV file with Excel.

Look here:

https://www.postgresqltutorial.com/export-postgresql-table-to-csv-file/

https://www.postgresql.org/docs/current/sql-copy.html

Cheers,
Paul

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.klaver@aklaver.com