Re: Column names and datatypes

Carl,

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(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Glenn Sullivan
> Sent: Friday, May 14, 2004 12:23 PM
> To: pgsql-general
> Subject: [GENERAL] 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
>