| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Objects in schemas question |
| Date: | 2003-12-30 17:25:06 |
| Message-ID: | 23885.1072805106@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Wong | 2003-12-30 17:29:38 | patching PostgreSQL on STP with dbt-2 |
| Previous Message | Tom Lane | 2003-12-30 17:20:03 | Re: Is my MySQL Gaining ? |