Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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
