Re: getTables not returning 10 columns etc

On Dec 8, 9:47 pm, p(dot)(dot)(dot)(at)fastcrypt(dot)com (Dave Cramer) wrote:
> On Thu, Dec 8, 2011 at 8:10 PM, the6campbells <the6campbe(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> > Is there any documentation that list for the all get* methods etc
> > where it is by design intent that the PG JDBC driver may not have a
> > result set with all the columns as documented in the JDBC docs?
>
> > For example getTables has 10 columns and the PG driver returns 5 or
> > the documentation uses upper case names such as TABLE_CAT but PG
> > driver returns lower case names etc.
>
> Which documentation ? By default postgres uses lower case names.
>
> You would have to provide a test case for use to diagnose this further.
>
>
>
> > --
> > Sent via pgsql-jdbc mailing list (pgsql-j(dot)(dot)(dot)(at)postgresql(dot)org)
> > To make changes to your subscription:
> >http://www.postgresql.org/mailpref/pgsql-jdbc
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-j(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-jdbc

re documentation
http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSetMetaData.html

re example

Server: 9.0.4 Driver: PostgreSQL Native Driver: PostgreSQL 9.1 JDBC3
(build 901)

ResultSet rs = meta.getTables(null, null, null, null);
ResultSetMetaData rsmd = rs.getMetaData();
System.out.println(rsmd.getColumnCount());

This will print the value of 5 not 10.

Change the code to
for (int i = 1; i <= rsmd.getColumnCount(); i++) {
System.out.println(rsmd.getColumnName(i));
}

http://docs.oracle.com/javase/6/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,
java.lang.String, java.lang.String, java.lang.String[])
returns names as follows was expecting upper case names similar to
rs.getString("TABLE_NAME")
table_cat
table_schem
table_name
table_type
remarks