Re: Support for DatabaseMetadata: getCatalogName, getTableName, getColumnLabel

[Dave Cramer <pg(at)fastcrypt(dot)com>]

Ken,

The backend does not provide us with this information, so it is not  
trivial to implement( or even possible in some cases) .

Dave
On 29-Dec-06, at 1:10 AM, Ken Johanson wrote:

> Greetings,
>
> Using the the driver supplied with PG 8.2 I am seeing the following  
> with DatabaseMetadata:
>
> a) getCatalogName(int): always empty
>
> b) getTableName(int) always empty
>
> c) getColumnLabel(int) always equal to getColumnName(i), i.e.:
> `SELECT foo AS bar from tbl`,
> both getColumnName and getColumnLabel return 'bar'. I believe (cant  
> recall for sure though) that getColumnLabel is behaving okay, but  
> getColumnName should instead return 'foo'
>
> I did not check the String argument equivalent to of these.
>
> Is there a configuration option in the driver or PG that I can  
> change to correct this, or are these just not fully implemented yet?
>
> Kind regards,
>
> Ken
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate