> 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.