Thread: Getting the real column name.

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.

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)
>