-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Il 10/02/2014 16:43, peterlen ha scritto: > We are using PostgreSQL 9.3. Something seems to have changed with > our psql command-line output since we first installed it. When I > run commands at my plsql prompt, I am getting a lot of debug > statements which I was not getting before. I am just trying to > find out how to tell psql not to display this output. As an > example, if I were to create a new 'test' schema, the output looks > like: > > gis_demo=# create schema test; DEBUG: StartTransactionCommand > DEBUG: StartTransaction DEBUG: name: unnamed; blockState: > DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, > children: LOG: statement: create schema test; DEBUG: > ProcessUtility DEBUG: CommitTransactionCommand DEBUG: > CommitTransaction DEBUG: name: unnamed; blockState: STARTED; > state: INPROGR, xid/subid/cid: 15099/1/1, nestlvl: 1, children: > CREATE SCHEMA gis_demo=# You have set the "client_min_messages" to "debug" level. If you launch SET client_min_messages TO notice; You should obtain just the "CREATE SCHEMA" message. Giuseppe. - -- Giuseppe Broccolo - 2ndQuadrant Italy PostgreSQL Training, Services and Support giuseppe.broccolo@xxxxxxxxxxxxxx | www.2ndQuadrant.it -----BEGIN PGP SIGNATURE----- Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJS+Pj3AAoJELtGpyN/y3je5zMQALBNbdLyIOIUI1cN0nwHX/Wb vg0QdQ4IOqcZkojEFVspD1dJ6cl827eymmhPgkYwol0VU+Lf7TidQuBrw1Xz1+zq cMA56atTdl1lHkR+gL9fNSX9xb2h/cTfc5ASm1FbspaiitB3Rx3MqWhJTRKWxwAt lrVQBt5/OXWr+9UVM0cJkLWhGo5WTtkkLJ2UZy0C5IdldoWy0FN/pxtqx36+iUhH 6/joGV1i4wg9MFBO5CC8+vEiSUirbAjRgKaOfg6a2+htQfQUV7MmA+tZx7Hi2O2n 9jVKkYXHsdLD275lGfI4c3qgBWI9kbXOgJMQUsunXZAZNxXmcoMxFvzYbjaI8zZS sSCFPt3Ztld9zT81wQMzPYxT8cGEcEfyG97iJQv4Xt7ILcxuxTn2AmmVAQs+JWXK ISfz68bYlzc3FDO72i7sVhlm1kOXhvSMry3pQuqu/v6E+TJN5OUAX1gGSuG4Cn2O rGh3THBC/W/8+GjfW51X/FfPPQHjcYqzjs8h3Qn86XiarQYQEMpNhtTdFGdnI1U4 P0dF9fu6k9Yx5MQhp9r/zV9lPLfk8E/cmAyV0xDAuP9Hv1mATmWomFmeIpEx91BM Afimb8JbOAfmZty/5Yj29WVNeKxa8hkyPplV9qdReup2UfcLddPhxRglZN33Ou8N GIx7YPPx5xs+mukF1kmg =QLyE -----END PGP SIGNATURE----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
