Re: JDBC types vs postgres types correspondation - Mailing list pgsql-jdbc

On Sat, 10 May 2008, Marco Solinas wrote:

> We have a problem with the JDBC types. We need to find out the
> correspondation table between jdbc types and postgresql type.
> What we're trying to do is to build a CREATE TABLE query where a column has
> to be of type "character varying", but we're not able to find the
> corresponding JDBC type.

You are getting hit by a bug in the JDBC driver.  The output of
DatabaseMetaData.getTypeInfo is supposed to be sorted by closest match to
DATA_TYPE, but it is not.  So you're just getting a random match for a
datatype that can represent text.

Kris Jurka