Postgres, benefit of named schema va public schema?
what is the benefit of a non-'public' schema.


A schema provides a standardized level of logical organization. If you've never used them, it's like asking what's the value of directories. You don't technically need to have them, but you can use them to


Organize &amp; Componentize
Control access
Reduce namespace-collisions


Also worth mentioning, the query planner can plan across schema boundaries. In the same sense that tools that operate on files can work across directories.


  Perhaps more to the point of the Question you could explain that there is nothing special about the schema named public, just an arbitrarily chosen name for the default schema. – Basil Bourque 1 min ago 


^ Valid point too. If you don't use your own customized schema, you're still using schema. It's just named public and placed in your search_path by default.