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