On Mon, 26 Mar 2001 21:20:13 -0500
"Jeff" <[EMAIL PROTECTED]> wrote:
> 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?
>
Just set up the table with the field you are wanting to have as a unique id as type
"serial".
eg:
create table auto_id (id serial, description varchar(32));
Cheers
Zak
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
