SQL INSERT Statement -- Multi-Row Insert - Mailing list pgsql-novice

From Alan Searles
Subject SQL INSERT Statement -- Multi-Row Insert
Date
Msg-id 1055598746.1090.9.camel@aurora
Whole thread Raw
Responses Re: SQL INSERT Statement -- Multi-Row Insert
List pgsql-novice
  Is PostgreSQL able to perform multi-row inserts using a single INSERT
statement as shown below ?

INSERT INTO table ( col1, col2, col3 )
       VALUES  ( value1, value2, value3 ),
               ( value4, value5, value6 ),
               ( value7, value8, value9 )

   Yes, I have looked through the PostgreSQL documentation, and it DOES
NOT appear as though it can.
   I was hoping that I did not read it right.

/Alan


pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Question regarding keyword checkboxes in database
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL INSERT Statement -- Multi-Row Insert