Connecting Postgresql to Google Sheets

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 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?

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!

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 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?

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.

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.