Home > mailing lists

multiple row insertion - Mailing list pgsql-general

From	test tester
Subject	multiple row insertion
Date	October 4, 2007 11:20:08
Msg-id	4640d9b40710040419m579d52f7gaf73d3fe1a6450de@mail.gmail.com Whole thread Raw
Responses	Re: multiple row insertion
List	pgsql-general

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?

From: "Pavel Stehule"
Date: 04 October 2007, 10:09:47
Subject: Re: Design Question (Time Series Data)

From: "Mikko Partio"
Date: 04 October 2007, 11:34:53
Subject: Re: multiple row insertion