Postgres Pro
Downloads
Home   >   mailing lists

Re: multiple row insertion - Mailing list pgsql-general

From Mikko Partio
Subject Re: multiple row insertion
Date
Msg-id 2ca799770710040434l296b5a95o7e62354c3485d5a8@mail.gmail.com
Whole thread Raw
In response to multiple row insertion  ("test tester" <test896@gmail.com>)
List pgsql-general
Tree view


On 10/4/07, test tester <test896@gmail.com> wrote:
In MySQL, I can insert multiple rows like this:

insert into cars values(5, "toyota"),(5,"ford"), etc.


How can I do something similiar in PostgreSQL?

Exactly the same way. Make sure though that your pgsql is new enough version (8.2 ?).

Regards

MP


pgsql-general by date:

Previous
From: "test tester"
Date:
Subject: multiple row insertion
Next
From: Stefan Schwarzer
Date:
Subject: Re: Find min year and min value