Re: Auto increment - Mailing list pgsql-sql

From Richard Rowell
Subject Re: Auto increment
Date
Msg-id 39b2e986$1_1@news.shreve.net
Whole thread Raw
In response to Auto increment  ("Mads Jensen" <astrup_jensen@hotmail.com>)
List pgsql-sql
In article <vnxr5.4053$nq.48129@twister.sunsite.auc.dk>, "Mads Jensen"
<astrup_jensen@hotmail.com> wrote:
> Hi
> 
> I'm a newbiw with pgsql:
> 
> 1: Haven't been able to find the officiel manual to pgsql. What's the
> complete URL?

Hmm, I don't know, I use the book which you can find with all the rest of the docs at:
http://www.postgresql.org/docs/index.html


> 2: How can I make an auto increment with PostGreSQL? is it "inherit"?

One of two ways.  Either make the data type "serial" or you can create a sequence and 
set the default value of the field to curval(sequence).




pgsql-sql by date:

Previous
From: John McKown
Date:
Subject: Re: Week of the Year?
Next
From: Andreas Tille
Date:
Subject: Order by in stored functions