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

From Maciek Sakrejda
Subject Re: My query table aliases don't exist in my application
Date
Msg-id AANLkTinVeH7vHo10GUSG3c412J5H0odEx3gjk6meL7Mh@mail.gmail.com
Whole thread Raw
In response to Re: My query table aliases don't exist in my application  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: My query table aliases don't exist in my application  (Hugo Garza <hiro2k@gmail.com>)
List pgsql-jdbc
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: My query table aliases don't exist in my application
Next
From: "Kevin Grittner"
Date:
Subject: Timing of notice delivery