Re: Autonumber - Mailing list pgsql-general

From Karel Zak
Subject Re: Autonumber
Date
Msg-id 20010507165916.A16963@ara.zf.jcu.cz
Whole thread Raw
In response to Autonumber  (Terry Fielder <terry@greatgulfhomes.com>)
List pgsql-general
On Thu, May 03, 2001 at 11:11:20AM -0700, Terry Fielder wrote:
> Is there an autonumber data type in postgreSQL?
>

"SERIAL"

    CREATE TABLE xxx (id SERIAL, data TEXT);

or see docs for 'create sequence' -- it's more controllable stuff.

        Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

pgsql-general by date:

Previous
From: Einar Karttunen
Date:
Subject: Re: Autonumber
Next
From: Tom Lane
Date:
Subject: Re: Permissions and views.