Alter table to add foreign key

From: Jason Tan Boon Teck <tanboonteck(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Alter table to add foreign key
Date: 2011-08-12 04:11:04
Message-ID: CAOv1NUrsipTDfCX-m5CUJpeKpU-9woVF_aj4zXCfWOcXdFcLZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

What is the full syntax of SQL to add foreign key to an existing table?

The online manual's syntax looks very simple compared to what I can achieve
with manually adding by phpPgAdmin.

--
Jason Tan Boon Teck

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Douglas Hyde 2011-08-12 08:24:42 new install, can't use - need password for postgres user
Previous Message Tom Lane 2011-08-11 21:31:08 Re: Backup Server Error "might need to increase max_locks_per_transaction"