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

Pgadmin3 v1.14.2 foreign keys

From: "Mary F(dot) Masterson" <zen(at)email(dot)hal-pc(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Pgadmin3 v1.14.2 foreign keys
Date: 2012-08-04 20:04:39
Message-ID: ee740aff704d5cac55c341e8fdab2643.squirrel@sqmail.hal-pc.org (view raw or flat)
Thread:
Lists: pgsql-novice

I searched the archives and didn't find the answer as to how to add
foreign keys to a table using pgadminIII v1.14.2.  I am very familiar with
relational databases and foreign keys, indices, etc., but I am a newbie to
postgresql. For instance, say I have two tables, "address" and
"addresstype", both within the same schema.  The column named "type" in
the "address" table is the foreign key to the "addresstype" table, the
primary key of which is named "addresstype_id".  I created those columns
and added the primary key constraints without any difficulty.  I tried
adding the foreign key constraint, by right-clicking the "constraints"
object for the "address" table in the object browser window and selecting
"add foreign key".  I cannot figure out the next steps.  Any help, please?
 Thank you.

Responses

pgsql-novice by date

Next:From: Csanyi PalDate: 2012-08-04 20:24:27
Subject: To get a Table or View like a Calendar with dates
Previous:From: James David SmithDate: 2012-08-03 15:38:31
Subject: Re: Understanding sequence function

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