Re: Returning tablename.column? - Mailing list pgsql-general

From Ron Johnson
Subject Re: Returning tablename.column?
Date
Msg-id 1058079733.18890.187.camel@haggis
Whole thread Raw
In response to Returning tablename.column?  (Kurt Overberg <kurt@hotdogrecords.com>)
List pgsql-general
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.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| 4 degrees from Vladimir Putin
+-----------------------------------------------------------+


pgsql-general by date:

Previous
From: Kurt Overberg
Date:
Subject: Returning tablename.column?
Next
From: Shridhar Daithankar
Date:
Subject: Re: Tuning PostgreSQL