Re: Performance of INSERT into temporary tables using psqlODBC driver

2018-09-09 Thread Tim Cross
padusuma writes: >>We are inserting large numbers (millions) of rows into a postgres >>database from a Javascript application and found using the COPY command >>was much, much faster than doing regular inserts (even with multi-insert >>commit). If you can do this using the driver you are using,

Re: Performance of INSERT into temporary tables using psqlODBC driver

2018-09-09 Thread padusuma
Hello Sergei, >> The data to be inserted into temporary tables is obtained from one or >> more >> queries run earlier and the data is available as a vector of strings. >You can not use "insert into temp_table select /*anything you wish*/" statement? >Or even insert .. select ... returning if you

Re: Performance of INSERT into temporary tables using psqlODBC driver

2018-09-09 Thread Sergei Kornilov
Hello > The data to be inserted into temporary tables is obtained from one or more > queries run earlier and the data is available as a vector of strings. You can not use "insert into temp_table select /*anything you wish*/" statement? Or even insert .. select ... returning if you need receive dat