Thread: references versus foreign keys

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?

Tom Allison <tallison@tacocat.net> writes:
> 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?

You have to use the more verbose syntax to establish a multi-column
reference.  For single-column keys it doesn't matter which way you
do it.

            regards, tom lane