Re: Auto incrementing an integer - Mailing list pgsql-sql

Sylte wrote:

>How do I construct a datatype that autoincrement in postgreSQL?
>
Use the SERIAL data type instead of an INT4.    Serial is an integer 
(INT4) that's default value is base on a sequence.

for example...

create table foo (  my_id serial not null,  my_data text
);