Skip site navigation (1) Skip section navigation (2)

Re: find foreign key name

From: danap(at)ttc-cmc(dot)net
To: pgsql-jdbc(at)postgresql(dot)org
Cc: "Tore Halset" <halset(at)pvv(dot)ntnu(dot)no>
Subject: Re: find foreign key name
Date: 2007-12-19 02:51:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Hi Tore,
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

MyJSQLView Project
Code | Browse | --- src/Panels/net/danap/myjsqlview
Class Class Method
getColumnNames() ....

// Make a final check to see if there are any keys columns
// columns in the table. If not then try foreign keys.

if (primaryKeys.isEmpty())
  rs = dbMetaData.getImportedKeys(tableMetaData.getCatalogName(1),				    

  while (
     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.
> Regards,
>   - Tore.
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

In response to

pgsql-jdbc by date

Next:From: Ken JohansonDate: 2007-12-19 05:30:06
Subject: Re: Patch for Statement.getGeneratedKeys()
Previous:From: Kris JurkaDate: 2007-12-18 21:10:40
Subject: Re: pgsql jdbc setObject JAVA_OBJECT error

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group