Skip site navigation (1) Skip section navigation (2)

rs.getMetaData.getTableName always return empty string

From: nowind_lee <nowind_lee(at)qq(dot)com>
To: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: rs.getMetaData.getTableName always return empty string
Date: 2012-02-12 10:17:09
Message-ID: tencent_355846A85F1763A159FB8792@qq.com (view raw or flat)
Thread:
Lists: pgsql-bugs
I've read some discussions before I write this post. I know that "rs.getMetaData.getTableName" always return empty string just because the developers think it should be alias name in the query, not the underlying table name, which is hard to implement, so it's best to leave it blank.


And also there is a "PGResultSetMetaData.getBaseTableName()" can be used to get the table name.


I understand this, but it make something very hard. Please see my question:


http://stackoverflow.com/questions/9247064/play2s-anorm-cant-work-on-postgresql


From the implementation of play's anorm framework, we know that most of other jdbc drivers all return the underlying table name in "rs.getMetaData.getTableName". It make the parse of result set of "join" query easily.


Since all other drivers have the same action, will postgresql driver do it too? I think return the underlying table name is much more useful than an empty string.

pgsql-bugs by date

Next:From: nowind_leeDate: 2012-02-12 10:42:26
Subject: rs.getMetaData.getTableName always return empty string
Previous:From: felix.gerzaguetDate: 2012-02-11 18:02:55
Subject: BUG #6452: psql: can't change client encoding from the command line

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group