Re: [GENERAL] Autoincremental

From: Charles Tassell <ctassell(at)isn(dot)net>
To: Matteo Colombo <matteo(at)calcol(dot)it>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Autoincremental
Date: 1999-08-15 20:04:55
Message-ID: 4.1.19990815170301.0098ca50@mailer.isn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 1999-08-15 20:27:17 Re: [GENERAL] User not in pg_shadow
Previous Message Charles Tassell 1999-08-15 20:02:52 Re: [GENERAL] User not in pg_shadow