Re: What is paging my psql
| От | lejeczek |
|---|---|
| Тема | Re: What is paging my psql |
| Дата | |
| Msg-id | 0dcb33c5-ca74-4003-9808-adfb4a2d3655@yahoo.co.uk обсуждение исходный текст |
| Ответ на | Re: What is paging my psql ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Ответы |
Re: What is paging my psql
|
| Список | pgsql-admin |
All three servers show the same:
-> $ psql --port=5437 -c '\pset' | egrep -i pager
pager 1
pager_min_lines 0
Two of them do not page the query I showed
-> $ psql --port=5438 --dbname=yja_discourse -c 'select * from pg_extension;'
oid | extname | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
-------+----------+----------+--------------+----------------+------------+-----------+--------------
13545 | plpgsql | 10 | 11 | f | 1.0 | |
16393 | hstore | 10 | 2200 | t | 1.8 | |
16521 | pg_trgm | 10 | 2200 | t | 1.6 | |
16602 | unaccent | 10 | 2200 | t | 1.1 | |
61507 | vector | 10 | 2200 | t | 0.8.1 | |
(5 rows)
third server pages - waits for user 'q' to switch back to shell prompt.
None of the servers - no that I could find - has $PAGER nor $PSQL_PAGER nor $SYSTEMD_PAGER set.
In fact:
-> $ set | egrep -i page
-> $ env | egrep -i page
shows nothing.
None of the servers - I failed to find - has psqlrc, not for the user nor system-wide.
On the two non-paging servers with this:
-> $ psql --port=5437 -c '\pset pager on'
Pager is used for long output.
done, the above query does not page - for the output is not long enough I believe.
On the third paging server - that does not change behaviour neither.
But I also noticed that after 'on/off' - this does not change and remains:
-> $ psql --port=5437 -c '\pset' | egrep -i pager
pager 1
pager_min_lines 0
Should that change/setting not be permanent, at least for the session-time being?
thanks, L.
В списке pgsql-admin по дате отправления: