/ 
DBIO-PostgreSQL-0.900000
/ DBIO::PostgreSQL::Introspect::Policies

NAME

DBIO::PostgreSQL::Introspect::Policies - Introspect PostgreSQL Row Level Security policies

VERSION

version 0.900000

DESCRIPTION

Fetches Row Level Security policy metadata from pg_catalog.pg_policy. Policy command types and USING/WITH CHECK expressions are decoded from PostgreSQL's internal representation.

METHODS

fetch

my $policies = DBIO::PostgreSQL::Introspect::Policies->fetch($dbh, $filter);

Returns a hashref keyed by schema.table. Each value is a hashref keyed by policy name. Each policy entry has: policy_name, command (SELECT, INSERT, UPDATE, DELETE, or ALL), permissive, using_expr, check_expr, roles (ArrayRef of role names, or undef for all roles).

AUTHOR

DBIO & DBIx::Class Authors

COPYRIGHT AND LICENSE

Copyright (C) 2026 DBIO Authors Portions Copyright (C) 2005-2025 DBIx::Class Authors Based on DBIx::Class, heavily modified.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.