From: | Ying Lu <ying_lu(at)cs(dot)concordia(dot)ca> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | "\d tablename" to get column name, and column type by using JDBC |
Date: | 2004-09-02 14:52:54 |
Message-ID: | 413733C6.5050604@cs.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
Emi
====================================================================================
Connection connection = DriverManager.getConnection(url,
"abc", "abc"); //username and pwd is "abc"
Statement stmt = connection.createStatement();
String query = "\\d test";
System.out.println("query: "+query);
ResultSet rs = stmt.executeQuery(query);
From | Date | Subject | |
---|---|---|---|
Next Message | Ennio-Sr | 2004-09-02 15:08:59 | Display of text fields |
Previous Message | Stephan Szabo | 2004-09-02 14:51:28 | Re: Foreign key locks |