sequence

From: "Vladimir V(dot) Zolotych" <gsmith(at)eurocom(dot)od(dot)ua>
To: pgsql-admin(at)postgresql(dot)org
Subject: sequence
Date: 2000-04-18 07:05:51
Message-ID: 38FC094F.EBF59629@eurocom.od.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all

What is the safe way to add record to a table
and get it id (generated by a sequence) consistently?

E.g.
1) add record (INSERT INTO...) to a table
(the record's id will be generated
automatically due the ``id SERIAL'' column were defined).

2) get the id of a just created record.

Thanks

--
Vladimir Zolotych gsmith(at)eurocom(dot)od(dot)ua

Responses

  • Re: sequence at 2000-04-18 16:18:35 from Andrew Perrin - Demography

Browse pgsql-admin by date

  From Date Subject
Next Message Raul Carvalho 2000-04-18 09:44:09 RE: Maintenance
Previous Message Rainer Mager 2000-04-18 00:48:03 RE: Maintenance