Re: My query table aliases don't exist in my application

Thank you guys, I will have to update my program code. But it makes a lot
more sense to have the columns with more signifcant names.

On Tue, Feb 1, 2011 at 4:52 PM, Maciek Sakrejda <msakrejda(at)truviso(dot)com>wrote:

> Right. Even if you explicitly include the table alias, PostgreSQL
> strips it out before sending column metadata, so according to the
> server, the column name of
>
> SELECT x.a FROM foo x;
>
> is just "a", not "x.a". The driver is just playing along. If you
> really like the alias names, you can use the somewhat perverse
>
> SELECT x.a as "x.a" FROM foo x;
>
> ---
> Maciek Sakrejda | System Architect | Truviso
>
> 1065 E. Hillsdale Blvd., Suite 215
> Foster City, CA 94404
> www.truviso.com
>