Re: [SQL] Auto incrementing an integer

[Thomas Swan]

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
);




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl