Re: Autonumber

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Terry Fielder <terry(at)greatgulfhomes(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autonumber
Date: 2001-05-07 14:59:16
Message-ID: 20010507165916.A16963@ara.zf.jcu.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

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

In response to

  • Autonumber at 2001-05-03 18:11:20 from Terry Fielder

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2001-05-07 15:07:16 select off of a view going slowly
Previous Message Vince Vielhaber 2001-05-07 14:56:20 Re: v7.1.1 Branched, Packaged and Released ...