Re: retrieving a serial number

From: Joachim Trinkwitz <jtr(at)uni-bonn(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: retrieving a serial number
Date: 2000-07-02 12:28:57
Message-ID: 87puowzpfa.fsf@wabe.in-bonn.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Robert B. Easter" <reaster(at)comptechnews(dot)com> writes:

> You can do something like this:
> $var = SELECT nextval('seq_name');
> INSERT INTO master (id, ...) VALUES ($var, ...);
> INSERT INTO slave1 (id, ...) VALUES ($var, ...);

Great feaure. What to do when importing some previous data from ascii
files -- can you automatically give a serial number in this way to?

Thanks in advance,
joachim

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-07-02 16:38:47 Re: Query about using arrays (for accessing pg_group)
Previous Message Greg Wickham 2000-07-02 07:20:23 Query about using arrays (for accessing pg_group)