auto increment - Mailing list pgsql-general

hi,

    i am creating a table and i want to add an auto incrementable field

    is that correct?

psql ival << EOF
create table partes (
codigo int not null auto_increment,
usuario varchar(15),
fecha date,
proyecto varchar(30),
horas int4,
trabajo varchar(100),
observaciones varchar(90),
primary key(codigo));
EOF

how can i do it?

thanks in advance,

marcos

--
m a r c o s @ i v a l . e s