Re: Problem with displaying "wide" tables in psql

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(dot)k(dot)muraviov(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
>