Re: Autoincremental value - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Autoincremental value
Date
Msg-id 20040813200923.GA8550@wolff.to
Whole thread Raw
In response to Autoincremental value  (adburne@asocmedrosario.com.ar)
List pgsql-general
On Fri, Aug 13, 2004 at 13:50:48 -0300,
  adburne@asocmedrosario.com.ar wrote:
> Hi I'm a newbie in postgresql, I came from MSSQL, MySQL and now
> I'm testing postgres.
> In mysql there is a way to make a second autoincrement field, just:

Use serial for the type. You probably want to read up on sequences
and the serial type (which is really a macro for an int plus a default
based on a sequence) as the semantics are not identical with autoincrement.

pgsql-general by date:

Previous
From: Josué Maldonado
Date:
Subject: Re: Autoincremental value
Next
From: Mage
Date:
Subject: Re: Autoincremental value