Re: [GENERAL] Autoincremental - Mailing list pgsql-general

From Charles Tassell
Subject Re: [GENERAL] Autoincremental
Date
Msg-id 4.1.19990815170301.0098ca50@mailer.isn.net
Whole thread Raw
In response to Autoincremental  (Matteo Colombo <matteo@calcol.it>)
List pgsql-general
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
>


pgsql-general by date:

Previous
From: Matteo Colombo
Date:
Subject: Autoincremental
Next
From: Charles Tassell
Date:
Subject: Re: [GENERAL] User not in pg_shadow