psql: \pset pager 'always'?
От | Antti Haapala |
---|---|
Тема | psql: \pset pager 'always'? |
Дата | |
Msg-id | Pine.GSO.4.44.0209101817330.15658-100000@paju.oulu.fi обсуждение исходный текст |
Список | pgsql-general |
I don't know if this is already done, but... I'm really annoyed by that little 'feature' of psql that decides whether to use pager or not. I personally use GNU 'less' with options -S -F as my pager, which allows me to scroll vertically AS WELL AS horizontally on long input. So a "use pager always" option with no strange automagic behaviour would be nice. Or do you consider this being readable (copyed verbatim from terminal window): template1=# select * from pg_class limit 1; relname | reltype | relowner | relam | relfilenode | relpages | reltuples | reltoastrelid | reltoastidxid | relhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids | relhaspkey | relhasrules | relhassubclass | relacl ----------------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+-------------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+- ------------+----------------+-------- pg_type | 71 | 1 | 0 | 1247 | 2 | 143 | 0 | 0 | t | f | r | 17 | 0 | 0 | 0 | 0 | 0 | t Until that I need to avoid queries with too _few_ resulting rows in psql. ;-) (select * from pg_class works brilliantly). -- Antti Haapala
В списке pgsql-general по дате отправления: