Re: Get a table name

>In general, no. That's because resultset columns can be "entangled" in more complex way than "column a of table b".

Actually, this *is* defined at the protocol level:

From the RowDescription message at
http://developer.postgresql.org/pgdocs/postgres/protocol-message-formats.html
:
...

Then, for each field, there is the following:

String

    The field name.
Int32

    If the field can be identified as a column of a specific table,
the object ID of the table; otherwise zero.

...

No idea whether JDBC exposes this or whether the server actually sends
the correct oids, or if this is just part of the protocol as a
future-proofing attempt.

---
Maciek Sakrejda | Software Engineer | Truviso

1065 E. Hillsdale Blvd., Suite 230
Foster City, CA 94404
(650) 242-3500 Main
(650) 242-3501 F
www.truviso.com