I know that you can use --variable="FETCH_COUNT=10000" from the psql command line, but internally that uses a CURSOR to batch the rows and [Redshift doesn't support CURSOR](https://forums.aws.amazon.com/thread.jspa?threadID=122664&tstart=0) so it's not an option when using psql to download data from Redshift.
Pavel's idea of having a single row mode option to replace FETCH_COUNT is interesting, does anyone have any problems with that or alternative ideas?
On Tue, Apr 23, 2013 at 1:05 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > > Isn't there already a way to set FETCH_COUNT from the command line? > (ie, I think there's a generic variable-assignment facility that could > do this) >
Christopher,
Tom is all right... from psql [1] command line we can do that:
$ bin/psql --variable=FETCH_COUNT=100 psql (9.3devel) Type "help" for help.