On Tue, Feb 23, 2010 at 9:48 AM, Yeb Havinga <yebhavinga@gmail.com> wrote:
> Greg Stark wrote:
>>
>> You can do \set FETCH_COUNT to have psql use a cursor automatically.
>>
>
> It seems like a big win in this case. What would be the downside of having a
> fetch_count set default in psql?
They were mentioned previously in this thread:
1) If an error occurs partway through the execution of the query you
might receive part of the result set.
2) psql won't be able to align the columns properly
--
greg