postgresql - 更改 PostgreSQL 和 pgAdmin III 中的消息输出

Question

这是一件小事，但对我来说有点烦人，似乎有一种方法可以配置它。假设我有以下内容:

CREATE OR REPLACE FUNCTION baz()
  RETURNS void AS
$BODY$
DECLARE
BEGIN
  RAISE NOTICE 'I also did some work!';
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

CREATE OR REPLACE FUNCTION bar()
  RETURNS void AS
$BODY$
DECLARE
BEGIN
  RAISE NOTICE 'I did a bunch of work and want you to know about it';
  PERFORM baz();
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

CREATE OR REPLACE FUNCTION foo()
  RETURNS void AS
$BODY$
DECLARE
BEGIN
  PERFORM bar();
END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

select foo();

我得到以下输出消息:

NOTICE:  I did a bunch of work and want you to know about it
CONTEXT:  SQL statement "SELECT bar()"
PL/pgSQL function "foo" line 4 at PERFORM
NOTICE:  I also did some work!
CONTEXT:  SQL statement "SELECT baz()"
PL/pgSQL function "bar" line 5 at PERFORM
SQL statement "SELECT bar()"
PL/pgSQL function "foo" line 4 at PERFORM
Total query runtime: 31 ms.
1 row retrieved.

我(通常)想要的只是看到类似这样的东西:

NOTICE:  I did a bunch of work and want you to know about it
NOTICE:  I also did some work!
Total query runtime: 31 ms.
1 row retrieved.

有没有办法控制/改变这个？同样，这是一件小事，几乎不值得在 Stackoverflow 上提问，但如果你有很多事情要做，它就会开始在输出中引入很多“噪音”，这让我已经重载的大脑在试图筛选它时受伤. :)

我正在使用 PostgreSQL 9.1.5 和 pgAdminIII 1.16.0

Answer 1

尝试使用 -q 选项连接。 q 代表 Quiet，可能正是您所需要的。

psql -q -d foo_db

你也可以试试:

• \set 冗长简洁
• \set quiet on