Hi, <br /><br /> i have two tables, <br />---------------------------------------------------------------<br
/><b>table1<br/><br />id type serial, name varchar;</b><br
/><b>--------------------------------------------------------------<br/> table 2<br /><br />name varchar;</b><br
/>---------------------------------------------------------------<br/><br />i want to insert the values of table 2 into
table1, with automatic id's.<br /><br />insert into table1(select * from table2);<br /><br />is not working, how can i
appendthe data to table 1 with auto incremented or nextval.<br /><br />-Nicholas I<br />