View Single Post

   
  #2 (permalink)  
Old 04-09-2008, 11:04 PM
Mikko Partio
 
Posts: n/a
Default Re: multiple row insertion

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

Reply With Quote