Re: retrieving a serial number - Mailing list pgsql-sql

"Robert B. Easter" <reaster@comptechnews.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