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

Reply via email to