> 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);
>
> i dont know if this is possible (inserting a set of entries via resultset
> from a select stmt in one command). If anyone has any answers, or
> workarounds pls do email me
Well, that syntax doesn't work on SQL Server either.
I think what you want is:
insert into table1(field1,field2) select field1, field2 from table2;
HTH,
-- Joe
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
