Why Use Multiple Schemas?

I mentioned that Postgres supports multiple clusters, databases, and
schemas, but an open question is why use multiple schemas, rather than placing everything in the "public" schema? By default,
search_path places everything
in the public schema (assuming a schema matching the current user name does not exist):

test=> SHOW search_path;
(1 row)

Continue Reading »