1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
# SQL definition for policy
# CAUTION: Do not modify this file unless you know what you are doing.
# Code generation can be broken if incorrect changes are made.
@include "ddlend"
@include "objlabel"
@include "prependedsql"
[CREATE POLICY ] {name} [ ON ] {table}
%if {permissive} %then
$br $tb [AS PERMISSIVE]
%else
$br $tb [AS RESTRICTIVE]
%end
$br $tb [FOR ] {command}
$br $tb [TO ]
%if {roles} %then
{roles}
%else
PUBLIC
%end
%if {using-exp} %then
$br $tb [USING (] {using-exp} [)]
%end
%if {check-exp} %then
$br $tb [WITH CHECK (] {check-exp} [)]
%end
;
@include "footer"
|