Re: column "id" is of type integer but expression is of type character

Thank you.

> Well, you've dropped the integer column from test, so now the INSERT
> command is trying to stuff the char(10) value from test into the integer
> column in lisa - which is what the error message is telling you.

INSERT INTO test SELECT * FROM lisa;

I need that test table primary key column (id) values are populated
automatically with new ids from serial sequence, but all other column values
are duplicatated.

In reality those tables contain large number of columns and  some column
names may be not known at script creation time.

So it is not possible not create column list instead of *

How to force PostgreSql to match columns by name, not by position so that
this command will work ?

Andrus.