Re: My query table aliases don't exist in my application - Mailing list pgsql-jdbc

From Hugo Garza
Subject Re: My query table aliases don't exist in my application
Date
Msg-id AANLkTiknR7yUeK+VUPGFVuQonMoMkfyZ90oyOtU8sSXE@mail.gmail.com
Whole thread Raw
In response to Re: My query table aliases don't exist in my application  (Maciek Sakrejda <msakrejda@truviso.com>)
List pgsql-jdbc
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@truviso.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

pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Timing of notice delivery
Next
From: yazan suleiman
Date:
Subject: Slow statement when using JDBC