Re: psql --echo-queries does not echo all queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gavin Wahl <gavinwahl(at)gmail(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: psql --echo-queries does not echo all queries
Date: 2025-10-25 14:32:41
Message-ID: 1971001.1761402761@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Gavin Wahl <gavinwahl(at)gmail(dot)com> writes:
> The -e/--echo-queries psql option is documented to "Copy all SQL
> commands sent to the server to standard output as well." However, it
> does not show queries sent to the server by -1/--single-transaction or
> by ON_ERROR_ROLLBACK.

Did you try

-E, --echo-hidden display queries that internal commands generate

?

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David Rowley 2025-10-25 22:03:46 Re: Segfault in RI UPDATE CASCADE on partitioned tables with LIKE+ATTACH child (attnum drift)
Previous Message Tom Lane 2025-10-25 14:31:05 Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results