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

how to Adding a foreign key to a table already created???

From: "leon alexander" <katsumitsu(at)ntlworld(dot)com>
To: <pgsql-chat(at)postgresql(dot)org>
Subject: how to Adding a foreign key to a table already created???
Date: 2003-08-23 14:33:37
Message-ID: 001601c36983$8f9c8e20$4f6f0150@ninjaiilfmsrao (view raw or flat)
Thread:
Lists: pgsql-chat
hi there,
i have already created a table.The next table (artist), i would like to create requires a foreign key (cd_no) from a table (cd) which cannot be created until the table (artist) is made. Can i add the foreign key (cd_no) too the 'artist' table later???
leon

pgsql-chat by date

Next:From: Nico KingDate: 2003-09-05 00:00:57
Subject: Question about Scripting in Postgresql.
Previous:From: alvisDate: 2003-08-23 13:10:38
Subject: Re: kylix3 connection problem

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