Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>> o Add SET SCHEMA
>>
>> What is this supposed to do (and how's it different from SET SEARCH_PATH)?
> I believe someone thought it was the SQL standard way of doing it.
> Probably needs to be checked though.
I can find no mention of it in SQL99. Given that the spec regards
schemas and users as nearly the same thing, I'd guess that SET SESSION
AUTHORIZATION is probably what they'd expect to do this.
regards, tom lane