Returning tablename.column?

From: Kurt Overberg <kurt(at)hotdogrecords(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Returning tablename.column?
Date: 2003-07-13 05:13:18
Message-ID: 3F10EA6E.9080804@hotdogrecords.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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...

...what it does now.

database=# select * from member;
id | firstname | lastname | etc
-----+---------------+--------------+--------
2 | larry | lewis |
3 | dave | johnson |

...what I'd like it to do.

database=# select * from member;
member.id | member.firstname | member.lastname | member.etc
------------+----------------------+---------------------+--------------
2 | larry | lewis |
3 | dave | johnson |

...this would make my life MUCH easier, and allow me to get some work
done this century. I'm using straight-up Tomcat 4 with postgresql
JDBC2 drivers. Thoughts? Suggestions? Would this be a JDBC driver
thing, or postgresql thing?

Thanks!

/kurt

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Galbavy 2003-07-13 06:15:11 Re: [GENERAL] MySQL gets $19.5 MM
Previous Message Bruno Wolff III 2003-07-13 02:25:32 Re: vacuum analyze after updating from CVS?