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

From: Bryn Llewellyn <bryn(at)yugabyte(dot)com>
To: Daniel Verite <daniel(at)manitou-mail(dot)org>
Cc: Christophe Pettus <xof(at)thebuild(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, rjuju123(at)gmail(dot)com, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Date: 2023-02-21 01:54:14
Message-ID: D0D44B9B-1474-4F78-806E-9AAA08E2971A@yugabyte.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> bryn(at)yugabyte(dot)com wrote:
>>
>> It seems a bit odd that psql has no syntax to ask for this in its interactive mode.
>
> daniel(at)manitou-mail(dot)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 search got me anywhere.) But now I know that what I asked about is possible and I’ve seen it work, I trust that I’ll remember the trick.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2023-02-21 02:00:29 Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Previous Message Jonathan S. Katz 2023-02-20 23:44:58 Re: Support logical replication of DDLs