Re: Get a table name

From: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
To: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
Cc: Gianvito Pio <pio(dot)gianvito(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Get a table name
Date: 2009-12-27 22:12:30
Message-ID: 895e58dd0912271412hbf14159w8b2d71600f098bc0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

>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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2009-12-28 01:28:55 Re: Get a table name
Previous Message Filip Rembiałkowski 2009-12-27 12:59:35 Re: Get a table name