Skip site navigation (1) Skip section navigation (2)

Re: foreign key

From: Eric McKeeth <eldin00(at)gmail(dot)com>
To: Haris <fbogdanovic(at)xnet(dot)hr>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: foreign key
Date: 2011-03-18 05:23:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
2011/3/16 Haris <fbogdanovic(at)xnet(dot)hr>

> How to make a foreign key in pgAdmin ?
> I want to make a foreign key that references
> a primary key.
> A primary key is of type "serial",
> does that mean that foreign key should be "integer" or
> some other type ?

Yes, your foreign key should be of type integer. Serial is just a shortcut
for creating an integer with an associated sequence and default setting.


In response to

pgsql-novice by date

Next:From: Andrew HoytDate: 2011-03-18 11:51:54
Subject: Postgresql iPhone
Previous:From: aaronenabsDate: 2011-03-17 22:17:04
Subject: Re: Accessing dead rows within postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group