pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Rowell <the_pitman@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Auto increment
Date: Sun, 03 Sep 2000 19:24:16 -0600
Message-ID: <39b2e986$1_1@news.shreve.net> (raw)
References: <vnxr5.4053$nq.48129@twister.sunsite.auc.dk>

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).





view thread (27+ messages)  latest in thread

Message-ID: <39b2e986$1_1@news.shreve.net>
Permalink:  ../39b2e986$1_1@news.shreve.net/
Also on:    postgresql.org/message-id/39b2e986$1_1@news.shreve.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: the_pitman@hotmail.com
  Subject: Re: Auto increment
  In-Reply-To: <39b2e986$1_1@news.shreve.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox