On 7/5/22 15:08, Bryn Llewellyn wrote:
> I was informed by this precedent:
>
> *truncate table u1.t1, t2;
> *
> It uses a comma-separated list of optionally qualified SQL names.
>
> And this:
>
> «
> *CREATE SCHEMA schema_name ...
> *»
Those are creating objects. Set search_path is setting a configuration
value.
> And then this:
>
> «
> *SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value |
> 'value' | DEFAULT }*
>
> value — New value of parameter. Values can be specified as...
> identifiers... or comma-separated lists of these, as appropriate for the
> particular parameter...
> »
>
> Notice that the token « value » in the syntax is not in quotes. I took
Pretty sure it is:
{ TO | = } { value | 'value' | DEFAULT }
--
Adrian Klaver
adrian.klaver@aklaver.com