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