Search Postgresql Archives

Re: multiple row insertion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "test tester" <test896@xxxxxxxxx>
Subject: Re: multiple row insertion
From: "Mikko Partio" <mpartio@xxxxxxxxx>
Date: Thu, 4 Oct 2007 14:34:41 +0300
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <4640d9b40710040419m579d52f7gaf73d3fe1a6450de@xxxxxxxxxxxxxx>

On 10/4/07, test tester <test896@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- multiple row insertion
  - From: test tester

Prev by Date: multiple row insertion
Next by Date: Re: Find min year and min value
Previous by thread: multiple row insertion
Next by thread: Re: multiple row insertion
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux