Sample Header Ad - 728x90

Postgres, benefit of named schema vs public schema?

13 votes
2 answers
15961 views
I am new to Postgres and I am trying to understand how schemas fit into everything and what is the benefit of a non-'public' schema. For example, does it provide security, access control benefits or something else? The setup I am working with is one where postgres owns the database and tables, but grants permissions to another user to select, insert, update, and delete. Would creating the tables in the 'public' schema vs 'myotherschema' make much of a difference?
Asked by Andre M (315 rep)
Oct 19, 2017, 05:24 PM
Last activity: Sep 18, 2025, 07:41 AM