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