DatabaseMetadata.getTypeInfo() does not report the correct JDBC type for timestamptz and timetz

[prrvchr]

Hi,

I use postgresql 42.7.1 JDBC driver.
If we look at the DATA_TYPE column returned for timetz and timestamptz by the getTypeInfo() method of DatabaseMetaData we get 92 and 93 instead of 2013 and 2014 respectively.
In addition, the name of these two types does not seem to correspond to those necessary when declaring the type of a column (ie: time with time zone and timestamp with time zone respectively).
What justifies it being like this?

[davecramer]

duplicate of #1766, this is a well known issue, please search the history for the reasons.
We do have a PR to fix. It needs to get merged in

[prrvchr]

We do have a PR to fix. It needs to get merged in

Great, I'll wait for that...