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