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

Поиск
Список
Период
Сортировка
Искать
От
Paul Förster
Тема
Re: How to export query results to excel file using psql command in postgresql
Дата
Msg-id
DB4C59C6-9FF6-48F9-B82E-12316D8E9B2B@gmail.com
Ответ на
How to export query results to excel file using psql command in postgresql (Naveen Kumar)
Список
Дерево обсуждения
How to export query results to excel file using psql command in postgresql Naveen Kumar <naveenmcp@gmail.com>
Re: How to export query results to excel file using psql command in postgresql Adrian Klaver <adrian.klaver@aklaver.com>
Re: How to export query results to excel file using psql command in postgresql Pavel Stehule <pavel.stehule@gmail.com>
Re: How to export query results to excel file using psql command in postgresql Paul Förster <paul.foerster@gmail.com> 
Hi Naveen,

> On 13. Aug, 2020, at 16:10, Naveen Kumar  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
В списке pgsql-general по дате отправления
Предыдущее
От: Pavel Stehule
Дата:
Следующее
От: Adrian Klaver
Дата:
FAQ