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
Last activity: Sep 18, 2025, 07:41 AM