Views are the abstraction layer: https://www.postgresql.org/docs/current/tutorial-views.html https://www.postgresql.org/docs/current/tutorial-views.html Your

Views are the abstraction layer: https://www.postgresql.org/docs/current/tutorial-views.html https://www.postgresql.org/docs/current/tutorial-views.html Your application layer "security system" is just row level security done outside the db.