Re: Returning tablename.column?

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Returning tablename.column?
Дата
Msg-id 1058079733.18890.187.camel@haggis
обсуждение исходный текст
Ответ на Returning tablename.column?  (Kurt Overberg <kurt@hotdogrecords.com>)
Список 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 по дате отправления:

Предыдущее
От: Kurt Overberg
Дата:
Сообщение: Returning tablename.column?
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Tuning PostgreSQL