Re: solaris tarballs and pl/java - Mailing list pgsql-general

From Ozz Nixon
Subject Re: solaris tarballs and pl/java
Date
Msg-id 4BC76C8E.1040109@gmail.com
Whole thread Raw
In response to Re: solaris tarballs and pl/java  (John R Pierce <pierce@hogranch.com>)
Responses Inserting multiple values, was Re: solaris tarballs and pl/java
Re: solaris tarballs and pl/java
List pgsql-general
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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: solaris tarballs and pl/java
Next
From: akp geek
Date:
Subject: General Question about database -- redirection