| From: | Francisco Reyes <lists(at)natserv(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Pgsql Novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: What are schemas? |
| Date: | 2002-05-01 14:40:45 |
| Message-ID: | 20020501103754.L46591-100000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Wed, 1 May 2002, Tom Lane wrote:
> Francisco Reyes <lists(at)natserv(dot)com> writes:
> > What are schemas?
> > I have a general/vague idea, but would like to better understand it.
>
> To my mind, schemas are the SQL-spec equivalent of subdirectories,
> folders, or namespaces: you can name stuff in a schema without concern
> for name conflicts against what the guy in the next cubicle is naming
> the stuff in his schema.
What is the advantage of this feature? To allow multiple users name their
tables with the same names?
Do you know if table spaces been considered in the design of the
schemas?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PJourdan | 2002-05-01 14:56:24 | error messages |
| Previous Message | Josh Berkus | 2002-05-01 06:13:53 | Re: Once again about 'OID' |