Re: Performance of INSERT into temporary tables using psqlODBC driver

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: padusuma <venkata(dot)adusumalli(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance of INSERT into temporary tables using psqlODBC driver
Date: 2018-09-09 07:45:27
Message-ID: 32611151536479127@iva1-16f33c6a446b.qloud-c.yandex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 data to application?

> If I need to use COPY FROM command, then the application would need to create a
> file with the data to be inserted
You can not using "copy from stdin" statement?

regards, Sergei

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message padusuma 2018-09-09 09:39:23 Re: Performance of INSERT into temporary tables using psqlODBC driver
Previous Message padusuma 2018-09-08 05:41:01 Re: Performance of INSERT into temporary tables using psqlODBC driver