Re: [HACKERS] psql additions

2011-09-12 Thread Andrew Dunstan
On 09/11/2011 11:43 PM, Robert Haas wrote: Second, I'd like to be able to set a minimum number of lines below which the pager would not be used, something like: \pset pagerminlines 200 Thoughts? Gee, why do I feel like we have something like this already? We do? We control columns,

Re: [HACKERS] psql additions

2011-09-12 Thread Peter Eisentraut
On mån, 2011-09-12 at 05:26 -0400, Andrew Dunstan wrote: On 09/11/2011 11:43 PM, Robert Haas wrote: Second, I'd like to be able to set a minimum number of lines below which the pager would not be used, something like: \pset pagerminlines 200 Thoughts? Gee, why do I feel

Re: [HACKERS] psql additions

2011-09-12 Thread Andrew Dunstan
On 09/12/2011 08:39 AM, Peter Eisentraut wrote: On mån, 2011-09-12 at 05:26 -0400, Andrew Dunstan wrote: On 09/11/2011 11:43 PM, Robert Haas wrote: Second, I'd like to be able to set a minimum number of lines below which the pager would not be used, something like: \pset pagerminlines

Re: [HACKERS] psql additions

2011-09-12 Thread Peter Eisentraut
On mån, 2011-09-12 at 09:01 -0400, Andrew Dunstan wrote: On 09/12/2011 08:39 AM, Peter Eisentraut wrote: On mån, 2011-09-12 at 05:26 -0400, Andrew Dunstan wrote: On 09/11/2011 11:43 PM, Robert Haas wrote: Second, I'd like to be able to set a minimum number of lines below which the

[HACKERS] psql additions

2011-09-11 Thread Andrew Dunstan
Here's a couple of ideas I had recently about making psql a bit more user friendly. First, it would be useful to be able to set pager options and possibly other settings, so my suggestion is for a \setenv command that could be put in a .psqlrc file, something like: \setenv PAGER='less'

Re: [HACKERS] psql additions

2011-09-11 Thread Robert Haas
On Sun, Sep 11, 2011 at 2:58 PM, Andrew Dunstan and...@dunslane.net wrote: Here's a couple of ideas I had recently about making psql a bit more user friendly. First, it would be useful to be able to set pager options and possibly other settings, so my suggestion is for a \setenv command that