<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
That makes sense. I'll just use a COPY statement instead like Hannu
suggests.<br>
<br>
Pierre C wrote:
<blockquote cite="mid:op(dot)vajyiejneorkce(at)immo(dot)peufeu(dot)com" type="cite">
<blockquote type="cite">
<pre wrap="">Does the psql executable have any ability to do a "fetch many", using a
server-side named cursor, when returning results? It seems like it tries
to retrieve the query entirely to local memory before printing to
standard out.
</pre>
</blockquote>
<pre wrap=""><!---->
I think it grabs the whole result set to calculate the display column
widths. I think there is an option to tweak this but don't remember which,
have a look at the psql commands (\?), formatting section.
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
John E. Beaver
Bioinformatics Developer
Harvard Medical School</pre>
</body>
</html>