From: "Joseph Syjuco" <joseph(at)asti(dot)dost(dot)gov(dot)ph>
To: <pgsql-sql(at)postgresql(dot)org>
Subject:
Date: 2001-09-03 09:02:36
Message-ID: FHEOJMCOMLCBGLEMAKOGMENPCCAA.joseph@asti.dost.gov.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Thanks

Responses

  • Re: at 2001-09-03 17:05:51 from Joe Conway
  • Re: at 2001-09-03 17:35:10 from Peter Eisentraut
  • Re: at 2001-09-03 17:45:45 from Stephan Szabo
  • Re: INSERT Syntax at 2001-09-03 19:33:42 from Josh Berkus

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Davis 2001-09-03 16:29:12 Re:
Previous Message Carolyn Lu Wong 2001-09-03 04:41:46 duplicated oid