insert multiple rows

From: "G" <gerard(at)interfold(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: insert multiple rows
Date: 2002-05-04 22:31:56
Message-ID: ILEPLGCLIJOCNINEJCJPGEKBDJAA.gerard@interfold.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrew McMillan 2002-05-05 00:07:14 Re: insert multiple rows
Previous Message Joel Burton 2002-05-04 13:52:11 Re: Tricky query