Re: "\d tablename" to get column name, and column type by using JDBC

On 02/09/2004 15:52 Ying Lu wrote:
> 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 following is the java code, by which I always get "   ERROR: syntax
> error at or near "\"      ".
>
> Some clues?

The \d command is a psql client feature. I has nothing to do with JDBC and
is not built into the server back-end (a few moments reading the source
code for psql would have shown you this). To obtain metadata through JDBC,
use the standard provided classes. If you don't know how to that then you
really need to learn JDBC. There's a good introductory tutorial on
java.sun.com

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business             |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+