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 Hoyt||Date: 2011-03-18 11:51:54|
|Subject: Postgresql iPhone|
|Previous:||From: aaronenabs||Date: 2011-03-17 22:17:04|
|Subject: Re: Accessing dead rows within postgresql|