Обсуждение: Autoincremental

Поиск
Список
Период
Сортировка

Autoincremental

От
Matteo Colombo
Дата:
Pgsql support autoincremental field like mysql ?

Thanks

Re: [GENERAL] Autoincremental

От
Charles Tassell
Дата:
Yes, it's called "serial"  IE:
create table my table (
    ndx    serial,
    name    text
);

"serial"  is just a shortcut that creates a "sequence" (a type that is
basically a counter) an sets the ndx field to be an int default
nextval('sequence_name')  Read the FAQ for a better explanation.

At 01:44 PM 8/15/99, Matteo Colombo wrote:
>Pgsql support autoincremental field like mysql ?
>
>Thanks
>