Re: FOREIGN KEY Reference on multiple columns

From: Luca Vernini <lucazeo(at)gmail(dot)com>
To: Weiss, Jörg <J(dot)Weiss(at)dvz-mv(dot)de>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: FOREIGN KEY Reference on multiple columns
Date: 2014-09-23 09:59:22
Message-ID: CAHZ=uVAE3cobpckU+oyYWwF+ENr0UmYAhgu+kRrwmOc+t=g1nw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

2014-09-23 11:54 GMT+02:00 Weiss, Jörg <J(dot)Weiss(at)dvz-mv(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Weiss 2014-09-23 11:38:10 Re: FOREIGN KEY Reference on multiple columns
Previous Message Weiss 2014-09-23 09:54:15 FOREIGN KEY Reference on multiple columns