references versus foreign keys

From: Tom Allison <tallison(at)tacocat(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: references versus foreign keys
Date: 2006-02-26 18:26:35
Message-ID: 4401F2DB.4060602@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Maybe this is too much of a noob question but bear with me.

I'm assuming that I have a choice between
CREATE TABLE (..) REFERENCES other
and
CREATE TABLE (..) FOREIGN KEY () REFERENCES other
What is the differences between the two and why/when would I choose one over the
other?

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2006-02-26 19:06:00 Re: references versus foreign keys
Previous Message Peter Weinzierl 2006-02-26 10:04:16 Select with Regular Expressions