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 testerTo: pgsql-general@postgresql.orgSent: Thursday, October 04, 2007 4:49 PMSubject: [GENERAL] multiple row insertionIn 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 RegardsAshish
INSERT INTO qsweb.core_board(board_name, entry_user_id, entry_date) VALUES ('a',1,now()),('b',1,now());----- Original Message ----- From: test testerTo: pgsql-general@postgresql.orgSent: Thursday, October 04, 2007 4:49 PMSubject: [GENERAL] multiple row insertionIn 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 RegardsAshish
----- Original Message ----- From: test testerTo: pgsql-general@postgresql.orgSent: Thursday, October 04, 2007 4:49 PMSubject: [GENERAL] multiple row insertionIn 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 RegardsAshish
insert into cars values(5, "toyota"),(5,"ford"), etc.
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
