Use the column type of SERIAL in your create table statement. This will
automatically create a sequence and default for the given column.
http://www.postgresql.org/users-lounge/docs/7.0/user/sql-createsequence.htm
for more on sequences.
----- Original Message -----
From: "Harry Wood" <harry.wood@ic.ac.uk>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, December 19, 2000 6:51 AM
Subject: [GENERAL] Auto incrementing fields. How?
> Anyone know how to create auto incrementing fields?
>
> --
> Harry
> harry.wood@ic.ac.uk
> http://www.doc.ic.ac.uk/~hw97/Nojer2
> Nojer2 on chat.yahoo.com and zapidonia.com
> ICQ number 18519769