But some possibility has a Linux itself. There is simple pager
column
.You can try (blogger engine break formatting):
postgres=# \pset tuples_only postgres=# \setenv PAGER column postgres=# select typname from pg_type limit 100; bool pg_type line _bool _varchar _inet _numeric bytea pg_attribute _line _bytea _int8 _cidr timetz char pg_proc float4 _char _point _cstring _timetz name pg_class float8 _name _lseg bpchar bit int8 json abstime _int2 _path varchar _bit int2 xml reltime _int2vector _box date varbit int2vector _xml tinterval _int4 _float4 time _varbit int4 _json unknown _regproc _float8 timestamp numeric regproc pg_node_tree circle _text _abstime _timestamp refcursor text smgr _circle _oid _reltime _date _refcursor oid point money _tid _tinterval _time tid lseg _money _xid _polygon timestamptz xid path macaddr _cid aclitem _timestamptz cid box inet _oidvector _aclitem interval oidvector polygon cidr _bpchar _macaddr _interval postgres=#It works together with
less
postgres=# \setenv PAGER '(column | less)' postgres=# select typname from pg_type; ...
Do you know some other nice pagers?
Well, it will not work as nicely with more complex values (like with spaces). Not to mention, that it's not really properly formatted. Would much prefer native psql solution...
ReplyDelete@Depesz: It was a first time when I used a "column" pager. It was just a game, nothing more
ReplyDeleteand linux "column" pager is enough just only for very simple layout.
ReplyDelete