Postgres Pro
Downloads
Home   >   mailing lists

Thread: Removing foreign keys

Removing foreign keys

From
"psql novice"
Date:
Hi,

Is it possible to remove foreign keys from a table?
--
____________________________________________
http://www.operamail.com
Get OperaMail Premium today - USD 29.99/year


Powered by Outblaze

Re: Removing foreign keys

From
"psql novice"
Date:
Nevermind, found the command :)

----- Original Message -----
From: "psql novice" <psql_novice@operamail.com>
Date: Wed, 16 Jul 2003 04:55:48 +0100
To: pgsql-novice@postgresql.org
Subject: [NOVICE] Removing foreign keys

> Hi,
>
> Is it possible to remove foreign keys from a table?
> --
> ____________________________________________
> http://www.operamail.com
> Get OperaMail Premium today - USD 29.99/year
>
>
> Powered by Outblaze
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html

--
____________________________________________
http://www.operamail.com
Get OperaMail Premium today - USD 29.99/year


Powered by Outblaze

Re: Removing foreign keys

From
Jean-Christian Imbeault
Date:
psql novice wrote:
>
> Is it possible to remove foreign keys from a table?

I don't exactly understand what you mean by "remove". Do you mean
dropping the whole column? Setting the field to null? Dropping the
foreign key constraint?

Jean-Christian Imbeault