Fabrízio and Tom, 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? Regards, Christopher On Wed, Apr 24, 2013 at 7:04 AM, Fabrízio de Royes Mello < fabriziome...@gmail.com> wrote: > > On Tue, Apr 23, 2013 at 1:05 PM, Tom Lane <t...@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. > > fabrizio=# \echo :FETCH_COUNT > 100 > > Regards, > > [1] > http://www.postgresql.org/docs/current/interactive/app-psql.html#AEN84903 > > -- > Fabrízio de Royes Mello > Consultoria/Coaching PostgreSQL > >> Blog sobre TI: http://fabriziomello.blogspot.com > >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello > >> Twitter: http://twitter.com/fabriziomello >