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

<div dir="ltr"><br />On Tue, Apr 23, 2013 at 1:05 PM, Tom Lane <<a
href="mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>>wrote:<br />><br />> Isn't there already a way to set
FETCH_COUNTfrom the command line?<br /> > (ie, I think there's a generic variable-assignment facility that could<br
/>>do this)<br />><br /><br />Christopher,<br /><br />Tom is all right... from psql [1] command line we can do
that:<br/><br />$ bin/psql --variable=FETCH_COUNT=100<br /> psql (9.3devel)<br />Type "help" for help.<br /><br
/>fabrizio=#\echo :FETCH_COUNT<br />100<br /><br />Regards,<br /><br />[1] <a
href="http://www.postgresql.org/docs/current/interactive/app-psql.html#AEN84903">http://www.postgresql.org/docs/current/interactive/app-psql.html#AEN84903</a><br
/><br/>-- <br />Fabrízio de Royes Mello<br />Consultoria/Coaching PostgreSQL<br />>> Blog sobre TI: <a
href="http://fabriziomello.blogspot.com">http://fabriziomello.blogspot.com</a><br/>>> Perfil Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/> >> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a><br/></div>