Would it be useful to implement the SET SCHEMA command from SQL92? (I
assume it's also in 99.)
I guess that SET SCHEMA should change the front of the search path, so
that it would change the schema reported by current_schema(). It would
be a simplified form of SET SEARCH_PATH.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
======================================== "Praying always with all prayer and supplication in the Spirit, and
watchingthereunto with all perseverance and supplication for all saints." Ephesians 6:18
