Re: Auto increment

From: "Richard Rowell" <the_pitman(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Auto increment
Date: 2000-09-04 01:24:16
Message-ID: 39b2e986$1_1@news.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In article <vnxr5(dot)4053$nq(dot)48129(at)twister(dot)sunsite(dot)auc(dot)dk>, "Mads Jensen"
<astrup_jensen(at)hotmail(dot)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).

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Tille 2000-09-04 05:18:00 Order by in stored functions
Previous Message John McKown 2000-09-03 18:07:32 Re: Week of the Year?