copy result from PostgreSQL
I am copying every result of Query (application pgAdmin) into Google Doc's Sheet. I am wonder if it is possible to set Postgress to insert Tab instead of semicolon(;) to separate values in columns - I would like to simply copy and paste from postgres to Google Doc's sheet.
If it is not possible, is there any way to write a macro in Google Doc's 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
Since JDBC within Apps Script doesn't yet support Postgres (for some reason), you can't script this directly in Google Sheets. You could definitely script this the Google Sheets API and the language of your choice (e.g. Python and Pandas make this a relatively simple task).
If you don't want to roll your own solution, check out SeekWell. It allows you to connect to databases and write SQL queries directly in Sheets. You can create a run a “Run Sheet” that will run multiple queries at once and schedule those queries to be run without you even opening the Sheet.
Disclaimer: I made this.