Struct ViewDef 

pub struct ViewDef {
    pub name: String,
    pub query: String,
    pub materialized: bool,
    pub security_invoker: bool,
}

A SQL view definition.

Fields

name: String

View name.

query: String

Underlying SQL query.

materialized: bool

Whether this is a MATERIALIZED VIEW.

security_invoker: bool

WITH (security_invoker = true) — evaluate the base tables with the CALLER’s privileges instead of the view owner’s.

Without it Postgres checks the base tables as the view OWNER, so any row-level security on them is bypassed: a tenant selecting through the view sees every tenant’s rows. Set this on any view over an RLS-protected table. Leave it off only for views that are deliberately owner-rights (a public projection that must be readable with no tenant context) — and say so in a comment, because the default is the unsafe direction. Requires PostgreSQL 15+; ignored on MATERIALIZED views, which Postgres does not support it for.

Implementations

impl ViewDef

pub fn new(name: impl Into<String>, query: impl Into<String>) -> Self

Create a standard (non-materialized) view.

pub fn materialized(self) -> Self

Mark as MATERIALIZED VIEW.

pub fn security_invoker(self) -> Self

Evaluate base tables with the caller’s privileges so their RLS applies.

Trait Implementations

impl Clone for ViewDef

fn clone(&self) -> ViewDef

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for ViewDef

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for ViewDef

fn eq(&self, other: &ViewDef) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl StructuralPartialEq for ViewDef