Clarification on SET SESSION AUTHORIZATION Syntax

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Matemática A3K <matematica(dot)a3k(at)gmail(dot)com>
Cc: "vishnupalani19(at)gmail(dot)com" <vishnupalani19(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Clarification on SET SESSION AUTHORIZATION Syntax
Date: 2026-11-13 03:17:54
Message-ID: CAKFQuwYfJiNSDpRENRbzJ566iikwDGzW_3v4Fk9xxcrXoAY_yw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thursday, November 12, 2026, Matemática A3K <matematica(dot)a3k(at)gmail(dot)com>
wrote:

>
> > SET [ SESSION | LOCAL ] SESSION AUTHORIZATION user_name;
>
> I first read it as "one or the other", but it is "one or the other or
> none", as you may see from my console log

The square brackets are defined to mean optional in this scheme. It would
be { SESSION | LOCAL } if the choice were mandatory.

David J.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2026-11-13 03:32:47 Re: Clarification on SET SESSION AUTHORIZATION Syntax
Previous Message Matemática A3K 2026-11-13 03:01:30 Re: Clarification on SET SESSION AUTHORIZATION Syntax