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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-chat by date

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