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


Wed, 31 Dec 2003 00:39:55 +0800
Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Objects in schemas question
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

Tue, 30 Dec 2003 12:25:06 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Objects in schemas question 