Thread: Schemas?

When does using schemas make sense? Is it more effective or is it just to make a
database more manageable?


Regards,

BTJ
--
-----------------------------------------------------------------------------------------------
Bjørn T Johansen

btj@havleik.no
-----------------------------------------------------------------------------------------------
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"
-----------------------------------------------------------------------------------------------

Bjørn T Johansen wrote:
> When does using schemas make sense? Is it more effective or is it
> just to make a database more manageable?

They are just a logical hierarchy that allows you to organize your
databases in more or less manageable ways.  There is no performance or
other physical benefit.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/