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