Make a column of type SERIAL. See
http://www.postgresql.org/docs/aw_pgsql_book/node88.html
----- Original Message -----
From: "Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 6:20 PM
Subject: [GENERAL] How to auto create a unique key for each newly added
record?
> Hi,
>
> How to if it is possible to let postgresql to auto assign unique key to
each
> new record that is added to the database?
>
> Thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
