Hello 2013/12/18 Sameer Thakur <samthaku...@gmail.com>
> On Wed, Dec 11, 2013 at 11:13 PM, Sergey Muraviov > <sergey.k.murav...@gmail.com> wrote: > > Hi. > > > > I've improved the patch. > > It works in expanded mode when either format option is set to wrapped > (\pset > > format wrapped), or we have no pager, or pager doesn't chop long lines > (so > > you can still use the trick). > > Target output width is taken from either columns option (\pset columns > 70), > > or environment variable $COLUMNS, or terminal size. > > And it's also compatible with any border style (\pset border 0|1|2). > > > > Here are some examples: > > > > postgres=# \x 1 > > postgres=# \pset format wrapped > > postgres=# \pset border 0 > > postgres=# select * from wide_table; > > * Record 1 > > value afadsafasd fasdf asdfasd fsad fas df sadf sad f sadf sadf sa df > > sadfsadfa > > sd fsad fsa df sadf asd fa sfd sadfsadf asdf sad f sadf sad fadsf > > * Record 2 > > value afadsafasd fasdf asdfasd > > > > postgres=# \pset border 1 > > postgres=# \pset columns 70 > > postgres=# select * from wide_table; > > -[ RECORD 1 ]--------------------------------------------------------- > > value | afadsafasd fasdf asdfasd fsad fas df sadf sad f sadf sadf sa > > | df sadfsadfasd fsad fsa df sadf asd fa sfd sadfsadf asdf sad f > > | sadf sad fadsf > > -[ RECORD 2 ]--------------------------------------------------------- > > value | afadsafasd fasdf asdfasd > > > > postgres=# \pset border 2 > > postgres=# \pset columns 60 > > postgres=# select * from wide_table; > > +-[ RECORD 1 ]---------------------------------------------+ > > | value | afadsafasd fasdf asdfasd fsad fas df sadf sad f | > > | | sadf sadf sa df sadfsadfasd fsad fsa df sadf as | > > | | d fa sfd sadfsadf asdf sad f sadf sad fadsf | > > +-[ RECORD 2 ]---------------------------------------------+ > > | value | afadsafasd fasdf asdfasd | > > +-------+--------------------------------------------------+ > > > > Regards, > > Sergey > > > > The patch applies and compile cleanly. I tried the following > \pset format wrapped > \pset columns 70. > Not in expanded mode > select * from wide_table works fine. > select * from pg_stats has problems in viewing. Is it that pg_stats > can be viewed easily only in expanded mode i.e. if columns displayed > are wrapped then there is no way to view results in non expanded mode? > regards > Sameer > The problem with non expanded mode is that all column headers have to be displayed on one line. Otherwise, it is difficult to bind values to columns. And I have no idea how to solve this problem. -- Best regards, Sergey Muraviov
