BUG #17911: Database or JDBC Driver Provides Incorrect Type

The following bug has been logged on the website:

Bug reference: 17911
Logged by: Stephen Bergeon
Email address: postgresql(at)bergeon(dot)org
PostgreSQL version: 15.2
Operating system: Windows 10
Description:

When the JDBC driver returns a ResultSet, both from obtaining table column
info, as well as from an actual query, the DATA_TYPE returned is incorrect
for Time-with-Time-Zone and Timestamp-With-Time-Zone columns. In both cases
the returned value returned indicates that the non-time-zone value is
returned.

This has been tested on multiple versions of PostgreSQL and its JDBC
driver through the latest release [database version 15.2 and JDBC driver
42.6.0].