Re: auto increment primary key

On Fri, Apr 05, 2002 at 02:21:19AM -0800, impala wrote:
> I created a table, want the integer/varchar primary
> key column to be incremented automatically when
> inserted a new row. How do I define the table to do
> that? I tried AUTO_INCREMENT and INCREMENT but
> postgres accept none of them.

create table foo (
bar    serial primary key,
 . . .

This implies the creation of a special table called a sequence which
does the auto-incrementing.

Regards, Frank