Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? - Mailing list pgsql-general

From Bryn Llewellyn
Subject Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Date
Msg-id D0D44B9B-1474-4F78-806E-9AAA08E2971A@yugabyte.com
Whole thread Raw
In response to Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
>> bryn@yugabyte.com wrote:
>>
>> It seems a bit odd that psql has no syntax to ask for this in its interactive mode.
>
> daniel@manitou-mail.org wrote:
>
> Backslash-semicolon is the syntax.

Thanks, Daniel. Yes, that works. And the server’s SQL statement log confirms this.

I’ve no idea how I might have found this without human help. (Neither generic Google search nor using the PG docs own
searchgot me anywhere.) But now I know that what I asked about is possible and I’ve seen it work, I trust that I’ll
rememberthe trick. 


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_dump'ed file contains "DROP DATABASE"
Next
From: Christophe Pettus
Date:
Subject: Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?