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