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

Поиск
Список
Период
Сортировка
От Bryn Llewellyn
Тема Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Дата
Msg-id D0D44B9B-1474-4F78-806E-9AAA08E2971A@yugabyte.com
обсуждение исходный текст
Ответ на Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?  ("Daniel Verite" <daniel@manitou-mail.org>)
Ответы Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?  (Christophe Pettus <xof@thebuild.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: pg_dump'ed file contains "DROP DATABASE"
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Thanks! Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?