Re: Getting the real column name.

Поиск
Список
Период
Сортировка
От Barry Lind
Тема Re: Getting the real column name.
Дата
Msg-id 3E9ADCAF.4020708@xythos.com
обсуждение исходный текст
Ответ на Getting the real column name.  (marian <marian@mail.jozep.com.au>)
Список pgsql-jdbc
Marian,

Currently there is no way to do this.  The server doesn't provide to the
client the information about the real column and table names used in the
query.  This will hopefully be fixed in 7.4, but for the time being
there isn't anything that can be done.

thanks,
--Barry

marian wrote:
> Hi,
>
> I am trying to get the real column name from a table while using a
> 'SELECT name AS "New Name" FROM stuff' type query.
> I want to be able to recover the real name but getCatalogName returns a
> null string and getColumnName returns the same as getColumnLabel.
>
> What is the best way to do this or should I just build a static hash map
> thingy.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Barry Lind
Дата:
Сообщение: Re: error getString() --> decodeUTF8 /
Следующее
От: Barry Lind
Дата:
Сообщение: Re: DriverManager.getConnection hangs