Re: "\d tablename" to get column name, and column type - Mailing list pgsql-general

From Ying Lu
Subject Re: "\d tablename" to get column name, and column type
Date
Msg-id 41373F34.3000908@cs.concordia.ca
Whole thread Raw
In response to Re: "\d tablename" to get column name, and column type by  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
Thanks a lot. Now I got it.


Doug McNaught wrote:

>Ying Lu <ying_lu@cs.concordia.ca> writes:
>
>
>
>>Hello,
>>
>>Under mysql, we have "desc tablename" to get the detail information
>>about a table. My question is about to get column name, and column
>>type for a specific table under PostgreSQL through JDBC.
>>
>>Assume we have a table named "test". Under PSQL, we can input "\d
>>test" to see the details about table "test" successufully.  However,
>>my main purpose is trying to get column name, column name of a table
>>through JDBC.
>>
>>
>
>The backslash commands are specific to 'psql'.  From Java you'll need
>to query the INFORMATION_SCHEMA or the system catalogs.
>
>-Doug
>
>


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: "\d tablename" to get column name, and column type by
Next
From: Graeme Hinchliffe
Date:
Subject: Nicer way to access field