Обсуждение: Objects in schemas question

Hi, quick questions related to phpPgAdmin development.

1. What objects can possibly appear in the pg_temp* schemas?  Is it just 
tables, views and sequences?

2. As above, but the pg_toast schema.  Tables only here?

3. Am I guaranteed that a temp schema is 'pg_temp_*' and a toast one is 
'pg_toast' and vice versa?

4. What about information_schema?  Is it always just going to be tables, 
views, functions and domains?

Can people create weird non-standard stuff in those schemas?

Chris

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