Lists: | pgsql-hackers |
---|
From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Objects in schemas question |
Date: | 2003-12-30 16:39:55 |
Message-ID: | 3FF1AA5B.2030109@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
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
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 |
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