| From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | SET SCHEMA? |
| Date: | 2002-08-16 05:38:00 |
| Message-ID: | 1029476280.28727.537.camel@linda |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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(dot)Elphick(at)lfix(dot)co(dot)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 watching thereunto with all perseverance
and supplication for all saints." Ephesians 6:18
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-08-16 05:42:02 | Re: Bug/Change in behavior for 7.3 vs 7.2.1 |
| Previous Message | Bruce Momjian | 2002-08-16 05:05:07 | Open 7.3 items, with names |