Joseph Syjuco writes:
> im new in postgresql (actually came from SQL Server) and i was trying a
> script like this
>
> insert into table1(field1,field2) values (select field1, field2 from table
> 2);
The correct syntax is:
INSERT INTO table1 (field1, field2) SELECT field1, field2 FROM table2;
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter