Re: Inserting a record into another table ... inside a

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