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.kla...@aklaver.com
