Thread: Creating relationship links in PostgreSQL via pgAdmin
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.
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