Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > 1. What objects can possibly appear in the pg_temp* schemas? Is it just > tables, views and sequences?
Indexes ... row types for tables ... > 2. As above, but the pg_toast schema. Tables only here? Ditto. > 3. Am I guaranteed that a temp schema is 'pg_temp_*' and a toast one is > 'pg_toast' and vice versa? Yes. > 4. What about information_schema? Is it always just going to be tables, > views, functions and domains? Wouldn't count on it. > Can people create weird non-standard stuff in those schemas? Certainly, wherefore you probably really shouldn't assume anything. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]