Re: automatic creation of oid - Mailing list pgsql-general

From Detlef Jockheck
Subject Re: automatic creation of oid
Date
Msg-id 200303011854.h21IsVD03783@krakatau.jockheck.de
Whole thread Raw
In response to Re: automatic creation of oid  (Oliver Elphick <olly@lfix.co.uk>)
List pgsql-general
Am Samstag, 1. März 2003 00:45 schrieben Sie:
> On Fri, 2003-02-28 at 20:10, Detlef Jockheck wrote:
> > Hi,
> >
> > I'm new to postgresql. How can automatically create unique object
> > identifyer during insertion of new data. I 've seen that a can use a
> > sequence, but I think there must be another way?
>
> Why must there?  Using a sequence is the correct way to do it.  To
> automate the process, declare a column of SERIAL type.  (SERIAL is
> shorthand for creating a sequence and attaching it to the column's
> default.)
Hi Oliver,

Yes! Thats what I was looking for. I've seen it in the documentation but
could'nt remember how it works. Thanks for the tip :-)

ciao
Detlef


--
# Dipl. Ing. (FH) Detlef Jockheck
# E-mail: detlef@jockheck.de
# -------------------------------

pgsql-general by date:

Previous
From: Jonathan Bartlett
Date:
Subject: Re: Locking rows
Next
From: "Mark Cave-Ayland"
Date:
Subject: plpgsql memory leak in 7.3.2?