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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
