Re: [GENERAL] auto number

[Peter Eisentraut]

On Tue, 22 Feb 2000, Marco Giardini wrote:

>  how do i set a table with an autonumebr field? I mean a field that it's
> automatically increased by one for each added record.

Use a SERIAL column.

E.g.:

create table x (a text, b serial);
insert into x(a) values ('abc');

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
[EMAIL PROTECTED]                   75262 Uppsala
http://yi.org/peter-e/            Sweden


************