Re: automatic creation of oid

Поиск
Список
Период
Сортировка
От Detlef Jockheck
Тема Re: automatic creation of oid
Дата
Msg-id 200303011854.h21IsVD03783@krakatau.jockheck.de
обсуждение исходный текст
Ответ на Re: automatic creation of oid  (Oliver Elphick <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: Jonathan Bartlett
Дата:
Сообщение: Re: Locking rows
Следующее
От: "Mark Cave-Ayland"
Дата:
Сообщение: plpgsql memory leak in 7.3.2?