Re: Pgadmin3 v1.14.2 foreign keys

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