select on multiple tables - Mailing list pgsql-jdbc

From Carterette, Ben
Subject select on multiple tables
Date
Msg-id E8730F1847CDD411B00100B0D07971D58CCC0D@MAIL
Whole thread Raw
Responses Re: select on multiple tables  (Rene Pijlman <rpijlman@wanadoo.nl>)
List pgsql-jdbc
I apologize in advance if this isn't the right place to ask this.

I have a query like "SELECT * FROM table1, table2" and I want to read values
out of a ResultSet.  What if the two tables have column names in common and
I can't predict the column numbers?  Is there any way to get table1.id and
table2.id?  rs.getString tells me "The column name table1.id not found."

thanks much

ben

pgsql-jdbc by date:

Previous
From: "chris markiewicz"
Date:
Subject: RE: hangs while getting large objects...
Next
From: Rene Pijlman
Date:
Subject: Re: select on multiple tables