multiple inserts - Mailing list pgsql-novice

From Oren Mazor
Subject multiple inserts
Date
Msg-id op.ssinv7h7v14azh@localhost.localdomain
Whole thread Raw
Responses Re: multiple inserts
Re: [despammed] multiple inserts
Re: multiple inserts
List 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?"

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Trigger and Trigger function.
Next
From: John DeSoi
Date:
Subject: Re: Trigger and Trigger function.