column name order matters in insert into foo from bar

hey,

it looks , as if when I have two tables, say
create table foo(
  a int,
  b varchar,
  c float
);

and :

create table bar(
  b varchar,
  a int,
  c float
);

migration of data from one to the other using

insert into foo select * from bar; will fail.
How can I walk around that please ?

--
GJ