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

From: "Leonardo Francalanci" <lfrancalanci(at)simtel(dot)ie>
To: "Ying Lu" <ying_lu(at)cs(dot)concordia(dot)ca>, <pgsql-general(at)postgresql(dot)org>
Subject: R: "\d tablename" to get column name, and column type by using JDBC
Date: 2004-09-02 14:16:54
Message-ID: KNEFJLENOMMIGOKNCBFAMEFJENAA.lfrancalanci@simtel.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

have a look at java.sql.Connection.getDatabaseMetadata()
(and the object, java.sql.DatabaseMetaData it returns)

> -----Messaggio originale-----
> Da: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]Per conto di Ying Lu
> Inviato: giovedì 2 settembre 2004 16.53
> A: pgsql-general(at)postgresql(dot)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.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);
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Boes 2004-09-02 14:21:07 Re: Join efficiency
Previous Message Jeff Boes 2004-09-02 14:14:58 Re: Possible to insert quoted null value into integer field?