Re: - Mailing list pgsql-sql

From Stephan Szabo
Subject Re:
Date
Msg-id Pine.BSF.4.21.0109031044040.76325-100000@megazone23.bigpanda.com
Whole thread Raw
In response to  ("Joseph Syjuco" <joseph@asti.dost.gov.ph>)
List pgsql-sql
On Mon, 3 Sep 2001, Joseph Syjuco wrote:

> 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

You can, but you don't need to use values.

insert into table1(field1, field2) select field1, field2 from table2;
should do what you want.



pgsql-sql by date:

Previous
From: Michael Davis
Date:
Subject: Re:
Next
From: "Josh Berkus"
Date:
Subject: Re: INSERT Syntax