trino icon indicating copy to clipboard operation
trino copied to clipboard

Support options property in PostgreSQL connector

Open takezoe opened this issue 7 months ago • 1 comments

Description

PostgreSQL JDBC driver can take options property to send connection initialization parameters to the PostgreSQL server which allows clients to specify the statement timeout, etc.

It would be great if we can specify those parameters for connections from Trino.

Additional context and related issues

See the Connection Parameters section of the doc below: https://jdbc.postgresql.org/documentation/use/

Release notes

( ) This is not user-visible or is docs only, and no release notes are required. (x) Release notes are required. Please propose a release note for me. ( ) Release notes are required, with the following suggested text:

# PostgreSQL connector
* Add `postgresql.jdbc.options` configuration property to specify connection initialization parameters sent to the PostgreSQL server ({issue}`issuenumber`)

takezoe avatar Jul 14 '24 00:07 takezoe