Copying result from pgAdmin to a spreadsheet

Question

I am copying every result of Query (application pgAdmin) into Google Docs Sheet.

I am wonder if it is possible to set Postgres to output tabs instead of semicolon ; to separate values in columns - I would like to simply copy and paste from Postgres to Google Docs sheet.

If it is not possible, is there any way to write a macro in Google Docs sheet?

I would like to ask one more question - how can I divide two values which I get by using select command (and how to demand from Postgres SQL to store values as for example double)?

Answer 1

In PGAdmin 4, you can achieve this by executing your sql query and then press F8 and it will export the query results.

Step 1:

Step 2: Now select the query result and click download query result in CSV format as shown below:

Step 3: Verify the query result

You are done.