Thread: Schema vs Namespace

Schema vs Namespace

From
Peter Eisentraut
Date:
What's the strategy for naming things schema or namespace?  In notice that
pg_dump messages are all about namespaces.  That seems confusing from a
user's viewpoint.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Schema vs Namespace

From
Tom Lane
Date:
Peter Eisentraut <peter_e@gmx.net> writes:
> What's the strategy for naming things schema or namespace?  In notice that
> pg_dump messages are all about namespaces.  That seems confusing from a
> user's viewpoint.

Probably the user-visible messages should all mention schemas.

I named the catalog pg_namespace because I didn't want to nail down
a presumption that the things in it are exactly equivalent to SQL
schemas; namespaces are an implementation mechanism to support schemas,
but not necessarily an equivalent concept.  But this bit of
implementation philosophy isn't very relevant for users.
        regards, tom lane