Re: Disable the more command

Froilan Mendoza wrote:
  >
  >On Fri, 21 Jul 2000, Marcos Barreto de Castro wrote:
  >
  >>      Can someone tell me how can I disable the more
  >> command at the end of any one page display in
  >> PostgreSQL 7.0 ? I simply don't want to be asked to
  >> press a key to continue displaying the result of a
  >> query.
  >
  >Hmm.  I don't have the answer to your question, but I have a question
  >which does the reverse -- how can I _enable_ the "more" function? .. when
  >I do, say \do, there are a lot of operators displayed, how can i see them
  >per page.

\pset pager


From psql manpage (in release 7.0.2):

              pager  Toggles the list of  a  pager  to  do  table
                     output. If the environment variable PAGER is
                     set, the output is piped  to  the  specified
                     program.  Otherwise more is used.

                     In  any case, psql only uses the pager if it
                     seems appropriate. That  means  among  other
                     things  that the output is to a terminal and
                     that the table would normally not fit on the
                     screen.   Because  of  the modular nature of
                     the  printing  routines  it  is  not  always
                     possible to predict the number of lines that
                     will actually be printed.  For  that  reason
                     psql  might  not  appear very discriminating
                     about when to use the pager and when not to.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Then Peter and the other apostles answered and said,
      We ought to obey God rather than men."
                                        Acts 5:29