Re: multiple row insertion

From: "Mikko Partio" <mpartio(at)gmail(dot)com>
To: "test tester" <test896(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: multiple row insertion
Date: 2007-10-04 11:34:41
Message-ID: 2ca799770710040434l296b5a95o7e62354c3485d5a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/4/07, test tester <test896(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Schwarzer 2007-10-04 11:41:20 Re: Find min year and min value
Previous Message test tester 2007-10-04 11:19:58 multiple row insertion