| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
| Cc: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: AW: Unhappy thoughts about pg_dump and objects inherited from template1 |
| Date: | 2000-11-09 16:04:39 |
| Message-ID: | 6531.973785879@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> I think the hierarchy goes:
> Environment->Catalog->Schema
> From what I can tell:
> 1. the environment contains truly general things like the SQL parser, the
> tools for connecting to the DB etc - which I assume also contains the
> user-authorization stuff.
In that case it would seem that environment maps to what we call an
installation --- if users are environment-wide then that's certainly
the natural mapping. Then database maps to catalog and schema is a
new feature within databases.
> 3. Schemas are what we call databases. They contain tables, views wtc.
Schemas are *not* databases, because (IIRC) it's possible for a single
session to access multiple schemas.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB | 2000-11-09 16:10:02 | AW: AW: Unhappy thoughts about pg_dump and objects inhe rited from template1 |
| Previous Message | Philip Warner | 2000-11-09 16:00:37 | Re: Question about reliability? |