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(at)postgresql(dot)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