Re: [GENERAL] batch insertion

2013-08-25 Thread Merlin Moncure
On Sat, Aug 24, 2013 at 7:15 PM, Korisk wrote: > Hi! > I want quick insert into db a lot of data (in form of triplets). Data is > formed dynamical so "COPY" is not suitable. > I tried batch insert like this: > > insert into triplets values (1,1,1); > insert into triplets values (1,1,1), (3,2,5),

Re: [GENERAL] batch insertion

2013-08-24 Thread Adrian Klaver
On 08/24/2013 05:15 PM, Korisk wrote: Hi! I want quick insert into db a lot of data (in form of triplets). Data is formed dynamical so "COPY" is not suitable. I tried batch insert like this: insert into triplets values (1,1,1); insert into triplets values (1,1,1), (3,2,5), (4,5,5); ... insert i

Re: [GENERAL] batch insertion

2013-08-24 Thread Steve Atkins
On Aug 24, 2013, at 5:15 PM, Korisk wrote: > Hi! > I want quick insert into db a lot of data (in form of triplets). Data is > formed dynamical so "COPY" is not suitable. COPY works just fine for dynamically generated data, and it's probably the right thing to use if you're bulk loading data (

Re: [GENERAL] batch insertion

2013-08-24 Thread Allan Kamau
On Sun, Aug 25, 2013 at 3:15 AM, Korisk wrote: > Hi! > I want quick insert into db a lot of data (in form of triplets). Data is > formed dynamical so "COPY" is not suitable. > I tried batch insert like this: > > insert into triplets values (1,1,1); > insert into triplets values (1,1,1), (3,2,5),

[GENERAL] batch insertion

2013-08-24 Thread Korisk
Hi! I want quick insert into db a lot of data (in form of triplets). Data is formed dynamical so "COPY" is not suitable. I tried batch insert like this: insert into triplets values (1,1,1); insert into triplets values (1,1,1), (3,2,5), (4,5,5); ... insert into triplets values (1,1,1), (3,2,5), (4