| From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christopher Manning <c(at)christophermanning(dot)org>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Proposal to add --single-row to psql |
| Date: | 2013-04-24 12:04:04 |
| Message-ID: | CAFcNs+pBhK=zL_a_TKxRNU1JPsdq+A+Bdoty8+_nryJcg1bwnQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeevan Chalke | 2013-04-24 12:34:19 | Re: REFRESH MATERIALIZED VIEW command in PL block hitting Assert |
| Previous Message | Simon Riggs | 2013-04-24 11:49:32 | pgsql: Make fast promotion the default promotion mode. |