Postgres Pro
Downloads
Home   >   mailing lists

RE: add primary key - Mailing list pgsql-novice

From mikhail malamud
Subject RE: add primary key
Date
Msg-id MABBJIIJCNOHJDEFAAJEEEKOCEAA.mikhail.malamud@drexel.edu
Whole thread Raw
In response to add primary key  ("mikhail malamud" <mikhail.malamud@drexel.edu>)
Responses RE: add primary key
List pgsql-novice
Tree view 
Can someone please tell me the answer to this simple question?

-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org]On Behalf Of mikhail malamud
Sent: Saturday, March 10, 2001 10:55 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] add primary key


ALTER TABLE Activity add
    CONSTRAINT  PRIMARY KEY
    (
        ActivityId
    )
What's wrong with this. How do I add primary key constraint.
I tried to look in the docs but I could not find the answer, can anyone
also point me to a place where I could find an answer to this question
without disturbing the entire mailing list with such a probably simple
question.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

pgsql-novice by date:

Previous
From: Charles Welch
Date:
Subject: Number of Records in a Table
Next
From: David Olbersen
Date:
Subject: Re: Number of Records in a Table