getColumnName() Problems - Mailing list pgsql-jdbc

Hi Folks

    I am using a simple select statement like:

select location_id as "Location" from resorts;

Then from the resultSetMetaData, I am trying to
use getColumnName() and getColumnLabel(), which
return the same value "Location".

  How can I get the original column name ie "location_id"
without issuing another query. I thought that
getColumnLabel would return "Location" and
getColumnName would return "location_id", but in the
simple example above both functions return the same
value of "Location".

    I am using PostgreSQL-7.2 jdbc driver and would
like to know if this is a bug, not implemented or is
my understanding of the two functions wrong.

Thanks
Joseph Rajkumar
--
email: rajkumar@telocity.com