Skip to main content

vsql - pset options unavailable

  • April 23, 2015
  • 1 reply
  • 4 views

Navin_C
Forum|alt.badge.img+2

Hi,

 

I am trying to see my output of all columns in one row, when using vsql prompt.

 

Normally when we have more columns then the width of screen the records go in multiple lines.

 

With postgreSQL psql prompt, there is an option of setting the pager to wrapped style

 

\pset format wrapped

 

 

But when tried with vsql, it shows this :

 

nnani=>\pset format wrapped
\pset: allowed formats are unaligned, aligned, html, latex.

 

 

Is there any other way I can achieve this in vsql, I don't want the outpout in horizontal format, I want it in vertical format and all the columns should we fitted to width of screen.

Can we put a feature request if this option in not available

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • April 24, 2015

Oh, and also note that you can pipe html2text's output through a pager program such as more, so it pauses every screenful, like so:

 

 $export PAGER='html2text | more'