Use getMetadata of Connection. According to jdocs, the DatabaseMetaData object can probably give you what you are looking for. Carl <|};-)> -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Glenn Sullivan Sent: Friday, May 14, 2004 12:23 PM To: pgsql-general Subject: Column names and datatypes 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
