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