Ticket #102 (new enhancement)

Opened 2 years ago

Last modified 2 months ago

Query stream

Reported by: jtv Assigned to: jtv
Priority: normal Milestone: 3.1
Component: performance Version: 2.6
Severity: normal Keywords:
Cc:

Description (Last modified by jtv)

It seems the COPY command now also supports the copying of ad-hoc query results—not just tables.

We ought to have a way of executing queries that returns its results in this way. It could be useful for programs that process large result sets in streaming fashion and do not need to keep the entire data set in memory.

Attachments

Change History

05/24/08 13:38:18 changed by jtv

  • description changed.

07/10/08 06:13:16 changed by tore.halvorsen@gmail.com

This should work - using libpq and copy seems works very well...

Any idea how the API will look in pqxx?

07/14/08 02:23:48 changed by anonymous

The API would be quite simple. I'm not sure in what form it should deliver its results: turning them into result objects could be complicated, so maybe they'll just have to be two-dimensional vectors of strings.

11/02/08 01:40:33 changed by jtv

  • milestone changed from 3.0 to 3.1.

Add/Change #102 (Query stream)




Change Properties
Action