Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting Postgresql to Google Sheets

Connecting Postgresql to Google Sheets

From
Siddharth Golia
Date:
Hi, 

I am trying to get data from PostgreSQL to Google sheets but I am unable to do the same. Google script allows connecting using JDBC Service - https://developers.google.com/apps-script/reference/jdbc/jdbc#getcloudsqlconnectionurl.

I think JDBC Doesn't support PostgreSQL. Is there any alternative on how we can import data to google sheets?

Thanks

Re: Connecting Postgresql to Google Sheets

From
Matthias Apitz
Date:
El día Mittwoch, Januar 19, 2022 a las 11:24:26 +0000, Siddharth Golia escribió:

> Hi,
> 
> I am trying to get data from PostgreSQL to Google sheets but I am unable to do the same. Google script allows
connectingusing JDBC Service - https://developers.google.com/apps-script/reference/jdbc/jdbc#getcloudsqlconnectionurl.
 
> 
> I think JDBC Doesn't support PostgreSQL. Is there any alternative on how we can import data to google sheets?
> 

We develop and run a huge Library Management System on top of PostgreSQL
(novadays 13.1) and this makes use of JDBC (postgresql-42.2.24.jar on
Linux).

    matthias

-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!

Re: Connecting Postgresql to Google Sheets

From
Ron
Date:
On 1/19/22 7:56 AM, Matthias Apitz wrote:
> El día Mittwoch, Januar 19, 2022 a las 11:24:26 +0000, Siddharth Golia escribió:
>
>> Hi,
>>
>> I am trying to get data from PostgreSQL to Google sheets but I am unable to do the same. Google script allows
connectingusing JDBC Service - https://developers.google.com/apps-script/reference/jdbc/jdbc#getcloudsqlconnectionurl.
 
>>
>> I think JDBC Doesn't support PostgreSQL. Is there any alternative on how we can import data to google sheets?
>>
> We develop and run a huge Library Management System on top of PostgreSQL
> (novadays 13.1) and this makes use of JDBC (postgresql-42.2.24.jar on
> Linux).

And I manage multiple systems who's applications connect via JDBC.


-- 
Angular momentum makes the world go 'round.

Re: Connecting Postgresql to Google Sheets

From
"David G. Johnston"
Date:
On Wed, Jan 19, 2022 at 6:22 AM Siddharth Golia <siddharth.golia@altlifelab.com> wrote:
I think JDBC Doesn't support PostgreSQL. Is there any alternative on how we can import data to google sheets?

It seems a bit ironic that searching on Google for "jdbc postgresql" turns up a driver as the first search result.

David J.