Re: multiple row insertion

i have version 8.1 and i want to know how to insert multiple rows in this version.

On 10/4/07, Ashish Karalkar < ashish.karalkar@info-spectrum.com> wrote:

INSERT INTO qsweb.core_board(board_name, entry_user_id, entry_date)
    VALUES ('a',1,now()),('b',1,now());

----- Original Message -----

From: test tester

To: pgsql-general@postgresql.org

Sent: Thursday, October 04, 2007 4:49 PM

Subject: [GENERAL] multiple row insertion

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?

 

 

insert into  cars (id,name) values (1,'toyota'),(2,'ford');

 

With Regards

Ashish