Re: Insert multiple Rows

Hi,

Saint X wrote:
> Hi, I have a program that need to send a Postgresql database a lot of
> rows, i'm doing it using FOR an INSERT, something like this
> for i = 0 to 1000
> {
>  insert into table(item1) VALUES (i);
> }
> 
> And so on, as you can imagine these consume a lot of resources and
> move so slowly, that's why I'm looking for a command to send more than
> one row at the time, something like
> 
> insert into table (item1) values ('1' / '2' / '3' / '4' ... / '1000');

You can do instead:

insert into table (item1) values ('1');
insert into table (item1) values ('2');
....
insert into table (item1) values ('1000');

As single query.

But better use COPY command or prepared statment.

Inserts slow commonly due to indexis and foreing keys.

-- 
Olleg Samoylov