On Mon, 20 Feb 2006, David Goodenough wrote:

> What is the best way of finding the column types in generic code. That is to
> say if I have a method with no knowledge of a specific table and I am about
> to do an insert and I wish to get the parameters in the correct format what
> APIs exist that allow me to find out the type of a named column. I have
> looked through the JDBC docs without success so far, but it may be that
> I am looking for the wrong thing. If I need to use a Postgresql only API
> that is fine.
>

DatabaseMetaData.getColumns or PreparedStatement.getParameterMetaData are
probably what you're looking for.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster