From: | Antti Haapala <antti(dot)haapala(at)iki(dot)fi> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | psql: \pset pager 'always'? |
Date: | 2002-09-11 14:14:22 |
Message-ID: | Pine.GSO.4.44.0209101817330.15658-100000@paju.oulu.fi |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Sandini | 2002-09-11 14:16:07 | Re: pgplsql and parameters question |
Previous Message | Roland Roberts | 2002-09-11 14:13:36 | Re: if exists select ... in plpgsql code |