Re: [GENERAL] multiple row insertion

[Ashish Karalkar]

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