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 [EMAIL PROTECTED] 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 watching thereunto with all perseverance and supplication for all saints." Ephesians 6:18 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
