Re: Postgres to Java type mapping

Paulo,

TEXT maps to String
TIMESTAMP maps to Timestamp
SERIAL maps to Integer

The rest are not in the jdbc spec, and as a result do not map directly.
However since postgres returns strings for everything you can map them
to a String and then manipulate the underlying byte buffer.

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Paulo Merson
Sent: Friday, January 11, 2002 2:47 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] Postgres to Java type mapping

Hello,

I'd appreciate if anyone could indicate what is the recommended Java
type (or class) to map the following Postgres SQL types. I couldn't find
any document or previous message with such information.

SERIAL
TEXT
TIMESTAMP
BIT(n)
BIT VARYING(n)
INET
MACADDR
CIDR

Thank's,

Paulo Merson
Summa Technologies - www.summa-tech.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly