Re: insert into help - Mailing list pgsql-sql

Hi,

 i have two tables,
---------------------------------------------------------------
table1

id type serial, name varchar;
--------------------------------------------------------------
table 2

name varchar;
---------------------------------------------------------------

i want to insert the values of table 2 into table 1, with automatic id's.

insert into table1(select * from table2);

is not working, how can i append the data to table 1 with auto incremented or nextval.

-Nicholas I