Re: Getting the real column name.

From: Barry Lind <blind(at)xythos(dot)com>
To: marian <marian(at)mail(dot)jozep(dot)com(dot)au>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Getting the real column name.
Date: 2003-04-14 16:07:11
Message-ID: 3E9ADCAF.4020708@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org)
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-04-14 16:08:31 Re: DriverManager.getConnection hangs
Previous Message Barry Lind 2003-04-14 16:04:04 Re: unterminated quoted string