Inserting multiple values, was Re: solaris tarballs and pl/java

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Ozz Nixon <ozznixon(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Inserting multiple values, was Re: solaris tarballs and pl/java
Date: 2010-04-15 19:49:43
Message-ID: 4BC76DD7.1000500@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 15/04/2010 20:44, Ozz Nixon wrote:
> Would this syntax work in PostgreSQL?
>
> |INSERT INTO MyTable (FirstCol, SecondCol)
> VALUES ('First',1),
> || ('||Second||',2),|
> | ('||Third||',3),|
> | ('||Fourth||',4),|
> | ('||Fifth||',5)||
> |
> Inserting 5 rows in a single Insert? (I am trying to implement this
> solution across many different backends) works on SQL Server 2008, need
> to make sure it will work on many others.

http://www.postgresql.org/docs/8.4/static/sql-insert.html

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2010-04-15 19:52:59 Re: solaris tarballs and pl/java
Previous Message akp geek 2010-04-15 19:49:19 General Question about database -- redirection