Hello postgres=# \pset format wrapped Output format (format) is wrapped. postgres=# select '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';
?column? --------------------------------------------------------------------------------------------------------------------- afadsafasd fasdf asdfasd fsad fas df sadf sad f sadf sadf sa df sadfsadfasd fsad fsa df sadf asd fa sfd sadfsadf a. .sdf sad f sadf sad fadsf (1 row) It works as expected but it is not supported for row view. So any fix of this mode should be nice Regards Pavel 2013/12/4 Sergey Muraviov <sergey.k.murav...@gmail.com> > Thank you for this trick. > It would be nice if this trick was documented. > > However, with the pager I can't see wide value on one screen, select and > copy it entirely. > And I have to press many keys to find the necessary part of the value. > There is no such problems with the patch. > > > 2013/12/3 Pavel Stehule <pavel.steh...@gmail.com> > >> Hello >> >> do you know a pager less trick >> >> http://merlinmoncure.blogspot.cz/2007/10/better-psql-with-less.html >> >> Regards >> >> Pavel Stehule >> >> >> 2013/12/3 Sergey Muraviov <sergey.k.murav...@gmail.com> >> >>> Hi. >>> >>> Psql definitely have a problem with displaying "wide" tables. >>> Even in expanded mode, they look horrible. >>> So I tried to solve this problem. >>> >>> Before the patch: >>> postgres=# \x 1 >>> Expanded display (expanded) is on. >>> postgres=# \pset border 2 >>> Border style (border) is 2. >>> postgres=# select * from pg_stats; >>> >>> +-[ RECORD 1 >>> ]-----------+------------------------------------------------------ >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> >>> -------------------------------------------------------------------------------- >>> ----------------------------------------------------------+ >>> | schemaname | pg_catalog >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> | >>> | tablename | pg_proc >>> >>> ... >>> >>> and after: >>> >>> +-[ RECORD 1 >>> ]-----------+-----------------------------------------------------+ >>> | schemaname | pg_catalog >>> | >>> | tablename | pg_proc >>> | >>> | attname | proname >>> | >>> | inherited | f >>> | >>> | null_frac | 0 >>> | >>> | avg_width | 64 >>> | >>> | n_distinct | -0.823159 >>> | >>> | most_common_vals | >>> {max,min,overlaps,has_column_privilege,date_part,int4 >>> >>> ,length,substring,sum,to_char,avg,int8,numeric,abs,generate_series,has_any_colum >>> >>> n_privilege,has_database_privilege,has_foreign_data_wrapper_privilege,has_functi >>> >>> on_privilege,has_language_privilege,has_schema_privilege,has_sequence_privilege, >>> >>> has_server_privilege,has_table_privilege,has_tablespace_privilege,has_type_privi >>> >>> lege,overlay,pg_has_role,point,stddev,stddev_pop,stddev_samp,text,time,timestamp >>> >>> tz,timezone,var_pop,var_samp,variance,age,float4,float8,int2,isfinite,pg_get_vie >>> >>> wdef,timestamp,bit_and,bit_or,mod,octet_length,polygon,substr,trunc,ts_headline, >>> >>> ts_rank,ts_rank_cd,area,bit,bit_length,box,bpchar,btrim,circle,date,date_trunc,i >>> >>> nterval,ishorizontal,isvertical,lag,lead,like,log,money,name,notlike,position,ro >>> >>> und,timetz,to_ascii,abbrev,abstime,array_fill,array_to_json,array_to_string,ceil >>> >>> ,ceiling,center,char,char_length,character_length,count,daterange,enum_range,exp >>> >>> ,floor,format,generate_subscripts,get_bit,gin_extract_tsquery,gin_extract_tsvect >>> or} >>> | >>> ... >>> | correlation | 0.254019 >>> | >>> | most_common_elems | >>> | >>> | most_common_elem_freqs | >>> | >>> | elem_count_histogram | >>> | >>> +-[ RECORD 2 >>> ]-----------+-----------------------------------------------------+ >>> | schemaname | pg_catalog >>> | >>> | tablename | pg_proc >>> | >>> | attname | pronamespace >>> | >>> | inherited | f >>> | >>> | null_frac | 0 >>> | >>> | avg_width | 4 >>> | >>> | n_distinct | 2 >>> | >>> | most_common_vals | {11,12410} >>> | >>> | most_common_freqs | {0.995274,0.00472627} >>> | >>> | histogram_bounds | >>> | >>> | correlation | 1 >>> | >>> | most_common_elems | >>> | >>> | most_common_elem_freqs | >>> | >>> | elem_count_histogram | >>> | >>> +-[ RECORD 3 >>> ]-----------+-----------------------------------------------------+ >>> >>> Best regards, >>> Sergey Muraviov >>> >>> >>> -- >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-hackers >>> >>> >> > > > -- > Best regards, > Sergey Muraviov >
