On Thu, 5 May 2005, John DeSoi wrote:
> Sure. I actually started to write that, but then assumed this would be
> known by anyone who created 300 schemas :).
John,
Ah, assumptions! :-)
> It is certainly my preference over worrying about the search_path. But if
> you are working in 300 schemas with the same structure I suspect you are
> looking for ways to simplify the code without using fully qualified tables.
Hmmm-m-m. Perhaps you are correct. I'd have thought of a loop, but I don't
know the organization of those schema. Anyway, thanks for removing my
puzzlement.
Rich
--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863