| From: | Frank Bax <fbax(at)sympatico(dot)ca> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: What does 'schema' mean ? |
| Date: | 2006-01-09 16:26:50 |
| Message-ID: | 5.2.1.1.0.20060109112001.027c6710@pop6.sympatico.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
At 03:39 PM 1/9/06, Joao Miguel Ferreira wrote:
>here's another one: what do database people mean by 'schema' ?
I was thinking about asking the same question, because PGSQL appears to
have two things called 'schema'. The pg_dump (ver 7.4.3) man page says:
-n (--schema) appears to say 'namespace' and 'schema' are
synonymous - "Dump contents of 'schema'".
-s option appears to say 'data definition' and 'schema' are
synonymous - "dump only the schema (data definitions), no data".
So, in summary, a schema (namespace) contains a schema (data definitions)?
Frank
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Tucknott | 2006-01-09 16:38:37 | Re: Triggers and speed - 7.4.5 / 8.0.3 |
| Previous Message | Jaime Casanova | 2006-01-09 16:15:34 | Re: how to recall the initial definition (CREATE TABLE) |