Re: multiple row insertion

["Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxxxx

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

Subject: 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