PostgreSQL query output as a excel file

Question

I want to save the result of a psql query as an Excel file. ie, I have a table named company with 5 column. I want to execute the query,

SELECT column_1,
       column_2,
     FROM company;

And I just want to save the result of this query as a Excel file. Is it possible in PostgreSQL? If yes then please explain it.

Thank you......

Community · Accepted Answer · 2017-05-23 11:43:42Z

4

You could use csv to save your data and open/work with them in Excel. Syntax would be something like:

Copy (SELECT column_1,
             column_2,
      FROM company; 
     ) 
To '/tmp/test.csv' With CSV;

This query would run on server. You could also make usage of \query which is running on your client and saving the data locally. See also another SE question

edited May 23, 2017 at 11:43

CommunityBot

11 silver badge

answered Sep 23, 2014 at 5:45

frlan

7,2953 gold badges36 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL query output as a excel file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related