insert multiple rows - Mailing list pgsql-novice

From G
Subject insert multiple rows
Date
Msg-id ILEPLGCLIJOCNINEJCJPGEKBDJAA.gerard@interfold.com
Whole thread Raw
Responses Re: insert multiple rows  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-novice
Hello,

Just getting started with postgres. Is there an equivalent sql command to
insert multiple rows? In mysql it's:

insert into table (a,b,c)
values (1,2,3), (4,5,6);

I exported 6000 rows from mysql using single inserts - it's rather slow
executing them one by one into progresql.

Thanks,
Gerard


pgsql-novice by date:

Previous
From: "Joel Burton"
Date:
Subject: Re: Tricky query
Next
From: "Joshua b. Jore"
Date:
Subject: Re: Limiting number of records to show.