Re: multiple inserts

"Oren Mazor" <oren.mazor@gmail.com> writes:
> 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)

We should have that (it's in the SQL spec) but no one's gotten around to
it.  You could fake it with

    insert into mytable
        select val1
        union all
        select val2
        union all
        ...

But if you are thinking of really large amounts of data (like more than
a few dozen rows), you really want to use COPY instead.  Neither the
union approach nor the still-unwritten multi-insert would be likely to
be pleasant to use for thousands/millions of rows.

            regards, tom lane