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

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


> -----Messaggio originale-----
> Da: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]Per conto di Ying Lu
> Inviato: giovedì 2 settembre 2004 16.53
> A: pgsql-general@postgresql.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
>