auto increment

From: Marcos <marcos(at)second(dot)ival(dot)es>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: auto increment
Date: 2000-11-09 10:56:39
Message-ID: 3A0A82E7.EDED0F1D@second.ival.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Perchine 2000-11-09 11:28:47 ERROR: Index 1821202 does not exist
Previous Message Hervé Piedvache 2000-11-09 09:50:24 Re: Really SLOW using GROUP BY ...!?