Re: - Mailing list pgsql-sql

From Joe Conway
Subject Re:
Date
Msg-id 014d01c1349a$b01727c0$0705a8c0@jecw2k1
Whole thread Raw
In response to  ("Joseph Syjuco" <joseph@asti.dost.gov.ph>)
List pgsql-sql
> 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





pgsql-sql by date:

Previous
From: Carolyn Lu Wong
Date:
Subject: duplicated oid
Next
From: posting-list@MailAndNews.com (Jari Aalto)
Date:
Subject: GRANT ALL ON TO GROUP failure