Thread: Pgadmin3 v1.14.2 foreign keys

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.

Mary,

Not sure about FK via the pgadminIII gui table/columns view tool.
If you launch a query window from pgadminIII,  you can enter a command
similar to the following and it will accomplish your goal.

ALTER TABLE <schema>.address ADD FOREIGN KEY(address)
       REFERENCES <schema>.addresstype(addresstype_id);



Rgds


Dave

> -----Original Message-----
> From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
> owner@postgresql.org] On Behalf Of Mary F. Masterson
> Sent: Saturday, August 04, 2012 4:05 PM
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] Pgadmin3 v1.14.2 foreign keys
>
>
>
> 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.
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To
> make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice