At 2008-06-30 13:17:42 +0200, srb@cuci.nl wrote:
>
> It seems that the most efficient way to communicate with the
> DB would be through PQexecParams(), which avoids the whole
> bytea-encoding issues.
Yes.
> Does it become $10 or ${10} or $(10) or is it simply not possible
> te reference more than nine parameters this way?
$10 etc.
> - Say that the SELECT returns 1000 rows of 100MB each, is there a way
> to avoid PQexecParams() from wanting to allocate 1000*100MB = 100GB
Use a cursor and keep executing FETCH.
-- ams