Re: Returning tablename.column?

On Sun, 2003-07-13 at 00:13, Kurt Overberg wrote:
> Gang,
>
> I just inherited a postgresql database that does NOT have unique column
> names across the database. I'm wondering if there's some switch in
> postgresql/JDBC2 that I can throw to make it return the columns in the
> form of tablename.columnname, rather then just by columnname. I've
> looked through all the documentation, but can't find anything that would
> let me do something like this...
[snip trivial example]

What's wrong with having non-unique column names? Many places
strive for that, since it makes visualizing key relationships
easier.

--
+-----------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| 4 degrees from Vladimir Putin
+-----------------------------------------------------------+