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
