SQL INSERT Statement -- Multi-Row Insert

From: Alan Searles <alien(at)attglobal(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL INSERT Statement -- Multi-Row Insert
Date: 2003-06-14 13:52:26
Message-ID: 1055598746.1090.9.camel@aurora
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-06-14 14:11:17 Re: SQL INSERT Statement -- Multi-Row Insert
Previous Message Josh Berkus 2003-06-13 20:06:20 Re: Question regarding keyword checkboxes in database