title: customize pager in psql
body: <p>When I use <code>psql</code>, the command line tool of PostgreSQL, in interactive mode, it lists data as paginated output. </p>
  
  <p>However, because I use <code>psql</code> in a terminal application which can handle long outputs itself, I rather would like to get the whole output without the paginating with the annoying <code>--more--</code> line.</p>
  
  <p>Is there any way to customise the paging behavior in <code>psql</code>? I tried to set <code>LESS</code> in the surrounding shell environment to <code>cat</code>, but this din't help.</p>
  
  <p>Any suggestions?</p>