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

[Ying Lu]

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.g etConnection(ur l,
"abc", "abc"); //username and pwd is "abc"
Statement stmt = connection.crea teStatement();
String query = "\\d test";
System.out.prin tln("query: "+query);
ResultSet rs = stmt.executeQue ry(query);

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Paul Thomas]

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 |
+------------------------------+---------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Leonardo Francalanci]

have a look at java.sql.Connec tion.getDatabas eMetadata()
(and the object, java.sql.Databa seMetaData it returns)

-----Messaggio originale-----
Da: pg************* ****@postgresql .org
[mailto:pg****** ***********@pos tgresql.org]Per conto di Ying Lu
Inviato: giovedì 2 settembre 2004 16.53
A: pg***********@p ostgresql.org
Oggetto: [GENERAL] "\d tablename" to get column name, and column type by
using JDBC
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.g etConnection(ur l,
"abc", "abc"); //username and pwd is "abc"
Statement stmt = connection.crea teStatement();
String query = "\\d test";
System.out.prin tln("query: "+query);
ResultSet rs = stmt.executeQue ry(query);

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Doug McNaught]

Ying Lu <yi*****@cs.con cordia.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_SCH EMA or the system catalogs.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Ying Lu]

Thanks a lot. Now I got it.
Doug McNaught wrote:

Ying Lu <yi*****@cs.con cordia.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_SCH EMA or the system catalogs.

-Doug

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org