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