On May 5, 2005, at 11:27 AM, Rich Shepard wrote:
> Pardon my ignorance, but why wouldn't it work to specify the schema
> with
> the table; e.g., update myschema.table1?
Sure. I actually started to write that, but then assumed this would be
known by anyone who created 300 schemas :).
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.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL