Re: Primary key

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Allan Kamau <kamauallan(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Primary key
Date: 2011-03-14 15:56:51
Message-ID: 4D7E3AC3.7020602@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14/03/2011 15:35, Allan Kamau wrote:

> CREATE SEQUENCE hy3_pack_seq MINVALUE 1000;
> CREATE TABLE hy3_pack
> (
> hy3_id INTEGER NOT NULL DEFAULT nextval('hy3_pack_seq') -- or hy3_id
> BIGINT NOT NULL DEFAULT nextval('hy3_pack_seq')

That's what SERIAL does for you, in one go - it's just syntactic sugar
for the above. Read all about it here:

http://www.postgresql.org/docs/9.0/static/datatype-numeric.html#DATATYPE-SERIAL

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-03-14 16:03:45 Re: Primary key
Previous Message Allan Kamau 2011-03-14 15:35:43 Re: Primary key