Drop foreign keys - Mailing list pgsql-general

From Andreas Schlegel
Subject Drop foreign keys
Date
Msg-id 1042027979.1961.1.camel@erde.cosmos
Whole thread Raw
Responses Re: Drop foreign keys
List pgsql-general
Hi,

I created some  references with foreign keys. But now I have to drop
some of the references. What is the way to do this? Is there a command
for this? Or have I drop the table  and recreate it?
Postgres gave the references names like "RI_ConstraintTrigger_494516".
If there is a way to drop them one by one how do I get the information
on which foreign key point these Postgres names?

All references are created like this:
... constraint tPerson_FK03 foreign key (titel)
   references tTitel (tnr)
   ON UPDATE CASCADE ON DELETE RESTRICT ...

Greetings,
Andreas



pgsql-general by date:

Previous
From: Hervé Piedvache
Date:
Subject: Get PostgreSQL work with Kylix 3 ?
Next
From: Søren Neigaard
Date:
Subject: Exporting data as SQL