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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
