PSQL 8.3+客户端查询结果显示 [英] PSQL 8.3+ client query results display

问题描述

一个相当愚蠢的问题，但是我似乎在文档或手册页中找不到答案.

Rather silly question, but I can't seem to find the answer in the docs or man pages.

我认为从8.3开始，psql CLI客户端将不会显示大型内联查询的结果.它通过管道传递到不太像"结果查看器，当您按q时该查看器消失.

Starting with 8.3 I think, the psql CLI client will not display the results of a large query inline. It pipes to a 'less-like' result viewer that disappears when you hit q.

这使得在后续查询或更新中使用来自第一个查询的数据非常困难.

This makes it very difficult to use data from the first query in subsequent queries or updates.

有人知道像旧客户端那样强制psql内联显示查询结果的开关或方法吗?

Does anyone know of a switch or way to force psql to display the query results inline, like the old client did?

\ x开关可以执行此操作，但是我需要多行视图.

edit: the \x switch does this, but I need the multiple row view.

推荐答案

\pset pager off

\pset pager on

\pset pager always

或者，根据自己的喜好配置寻呼机

这篇关于PSQL 8.3+客户端查询结果显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！