Re: Primary & Foreign Keys in pgAdmin

On 15/03/2012 21:50, MrTeeth wrote:
> I was wondering can some give me an explanation on how to assign primary and
> foreign keys in pgAdmin?
>
> I can't find any information online.
>
> For example...I've got a Student table with all their details (address,
> d.o.b. and etc.). I'm going to add a student_number to the table and make it
> a primary key.

In the tree view on the left, right-click on the table and select "New
object", then "New primary key".

If the table already has a primary key, you can drop it and make your
new student number the PK instead. Click the "+" to see the table
attributes; under "constraints", select the PK, right-click and select
"Delete/drop". Add the new PK as above.

>
> I just want to know how do I do that using pgAdmin? And if you may be kind
> to explain give me further information on using Primary Keys in postgreSQL
> (and pgAdmin). The same case with the foreign keys.

Any tutorial on databases will explain PKs and FKs much better than I
can; they're not specific to Postgres.

HTH,

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie