Column names and datatypes

[Glenn Sullivan <glenn.sullivan@varianinc.com>]

I need to acquire the list of all column names and datatypes
from a table through the JDBC interface using an sql command.
What I want is available in "psql" with the "\d tablename"
command, but I cannot figure out how to get these via an sql
command.  Can anyone help?

Thanks,

Glenn


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faqs/FAQ.html