Re: Proposal to add --single-row to psql

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 <
fabriziomello(at)gmail(dot)com> wrote:

>
> On Tue, Apr 23, 2013 at 1:05 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
>