Tom Lane 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.
SQL99 has SET PATH (part 5, clause 14.4).
--
Peter Eisentraut peter_e@gmx.net