POSTGRESQL: CREATE POLICY
top of page
CerebroSQL

PostgreSQL:  

CREATE POLICY

Topic

CREATE POLICY name ON table_name
[ FOR { ALL | SELECT | INSERT | UPDATE | DELETE } ]
[ TO { role_name | PUBLIC | CURRENT_USER | SESSION_USER } [, ...] ]
[ USING ( using_expression ) ]
[ WITH CHECK ( check_expression ) ]

Example

bottom of page