How to discern a reference column from within java??

From: "David A(dot) Bartmess" <dingodave(at)edingo(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: How to discern a reference column from within java??
Date: 2002-06-09 17:51:26
Message-ID: 1023645087.2690.47.camel@Dingo.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


I am trying to figure out how to discern a reference column (as shown
below) inside a java object containing the various columns in a specific
row of a table.

The table looks like:

CREATE TABLE TempTbl AS
(
id serial,
type int references TypesTbl
);

But I cannot find a way inside the jdbc API to figure out if a
particular column is a reference to another table's row. Such as:

// These are examples of possible code
TempTbl tmptbl = new TempTbl();
tmptbl.connect();
tmptbl.readRow();

...
if (tmptbl.getColumn("type").isReference())
{
TypesTbl typestbl = new TypesTbl();
tmptbl.setColumn("type",
typestbl.getRowRef(tmptbl.getColumn("type"));
}

Am I missing something in the API?

Thanks for any help!
--
David A. Bartmess
Software Configuration Manager / Sr. Software Developer
eDingo Enterprises
http://edingo.net

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Serguei Mokhov 2002-06-09 19:31:45 Re: Java GUI development
Previous Message Jason Davies 2002-06-09 16:35:19 Re: Compiling postgres to is jdbc