multiple inserts

From: "Oren Mazor" <oren(dot)mazor(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: multiple inserts
Date: 2005-06-17 13:32:21
Message-ID: op.ssinv7h7v14azh@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi all,

I'm wondering if it is at all possible to do a mass insert into a table
using only a single query?

Something along the lines of:

insert into mytable values (val1), (val2), (val3)

rather than doing three discrete insert into statements.

this seems like something that should be there, but a week's worth of
googling hasnt turned anything up.

thanks
Oren

--
A voice crackles in Calvin's radio:
"Enemy fighters at two o'clock!"
"Roger. What should I do until then?"

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John DeSoi 2005-06-17 13:54:22 Re: Trigger and Trigger function.
Previous Message Michael Fuhr 2005-06-17 12:59:04 Re: Trigger and Trigger function.