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