As Kris indicated perhaps FK_NAME should do it. I have
used something a little different Im not sure why unless
I looked a little closer, but this what I have
Code | Browse | --- src/Panels/net/danap/myjsqlview
Class TableTabPanel_PostgreSQL.java Class Method
// Make a final check to see if there are any keys columns
// columns in the table. If not then try foreign keys.
rs = dbMetaData.getImportedKeys(tableMetaData.getCatalogName(1),
if (columnNamesHashMap.containsValue(rs.getString("PKCOLUMN_NAME")) &&
I was reluctant to access system catalogs directly in order to
derive the info. The above or FK_NAME would be a better way
to isolate from future changes in system catlogs.
> On Dec 18, 2007, at 10:36 , Heikki Linnakangas wrote:
>> Tore Halset wrote:
>>> I want to programatically drop a foreign key constraint via jdbc.
>>> How can I find the foreign key name for a PostgreSQL foreign key
>>> via jdbc? I know all about the related tables and columns, but not
>>> the name of the constraint.
>> You can query the pg_constraint catalog table:
>> There seems to be some example queries in the user comments that you
>> might be interested.
> Thanks. I was hoping for something easy in
> DatabaseMetaData#getExportedKeys.. :) But looking at pg_constraint
> should work fine.
> - Tore.
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
In response to
pgsql-jdbc by date
|Next:||From: Ken Johanson||Date: 2007-12-19 05:30:06|
|Subject: Re: Patch for Statement.getGeneratedKeys()|
|Previous:||From: Kris Jurka||Date: 2007-12-18 21:10:40|
|Subject: Re: pgsql jdbc setObject JAVA_OBJECT error|