Insert more than one t-uple in a single sql

From: "Gonzalo Villegas" <chalo1970(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Insert more than one t-uple in a single sql
Date: 2006-02-09 22:57:03
Message-ID: BAY112-DAV19105DCB6C39371A6D3BFFA9030@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm trying to insert more than one t-uple in a single sql query. Just like

copy table (field1,field2,...) from ....

It must be something like

insert into table (field1,field2,...) values (v1,v2,...),(b1,b2,...),
(c1,c2,...)

Thanks in advance!

Gonzalo A. Villegas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-02-09 23:13:30 Re: Insert more than one t-uple in a single sql
Previous Message Tom Lane 2006-02-09 22:53:29 Re: referential integrity without trigger