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