Schema vs Namespace

Started by Peter Eisentrautover 23 years ago2 messages
#1Peter Eisentraut
peter_e@gmx.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Eisentraut (#1)
Re: Schema vs Namespace

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