That is what I need. Thanks.
Glenn
Carl E. McMillin wrote:
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
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
