Postgres Pro
Downloads
Home   >   mailing lists

Re: FOREIGN KEY Reference on multiple columns - Mailing list pgsql-sql

From Luca Vernini
Subject Re: FOREIGN KEY Reference on multiple columns
Date
Msg-id CAHZ=uVAE3cobpckU+oyYWwF+ENr0UmYAhgu+kRrwmOc+t=g1nw@mail.gmail.com
Whole thread Raw
In response to FOREIGN KEY Reference on multiple columns  (Weiss, Jörg <J.Weiss@dvz-mv.de>)
Responses Re: FOREIGN KEY Reference on multiple columns
List pgsql-sql
Tree view 
2014-09-23 11:54 GMT+02:00 Weiss, Jörg <J.Weiss@dvz-mv.de>:
> Hi!
Hi.

> Is it possible to create a “FOREIGN KEY CONSTRAINT” with references to
> multiple columns of the reference table?

Yes, it is.

see here:
http://www.postgresql.org/docs/9.3/static/ddl-constraints.html
Section 5.3.5 there are some examples. One of them has multiple
columns, just like your case.

> Regards …

Regards.

pgsql-sql by date:

Previous
From: Weiss, Jörg
Date:
Subject: FOREIGN KEY Reference on multiple columns
Next
From: Weiss, Jörg
Date:
Subject: Re: FOREIGN KEY Reference on multiple columns