Re: How to use serial variable to insert into muiti-recrods? - Mailing list pgsql-sql

hu js wrote:
> run:
> "CREATE TABLE xxx
> (
> id serial NOT NULL,
> name character varying
> );
> insert into xxx select default values,place_name from air_bui;"

insert into xxx (name) SELECT place_name FROM ...

HTH
--  Richard Huxton Archonet Ltd