Thread: Creating relationship links in PostgreSQL via pgAdmin

Creating relationship links in PostgreSQL via pgAdmin

From
MrTeeth
Date:
Hi guys,

I created a databse with four tables in pgAdmin. It was coded in PostgreSQL.

I was wondering how do you create replationship links in pgAdmin? I've
searched google and youtube, but can't seem to find a tutorial on it.

If someone can explain how to do this, i'll be grateful.

Here's a picture of how I designed my datase to relate:
http://i1130.photobucket.com/albums/m538/mistateeth/02.jpg

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Creating-relationship-links-in-PostgreSQL-via-pgAdmin-tp5581358p5581358.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


Re: Creating relationship links in PostgreSQL via pgAdmin

From
Guillaume Lelarge
Date:
On Tue, 2012-03-20 at 14:58 -0700, MrTeeth wrote:
> Hi guys,
> 
> I created a databse with four tables in pgAdmin. It was coded in PostgreSQL.
> 
> I was wondering how do you create replationship links in pgAdmin? I've
> searched google and youtube, but can't seem to find a tutorial on it.
> 
> If someone can explain how to do this, i'll be grateful.
> 

You have to select your table in the database browser, then select the
constraints node, and choose in the contextual menu to add a new foreign
key.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com