The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { safeSql } from '../pg-format'
export const POLICIES_SQL = /* SQL */ safeSql`
select
pol.oid :: int8 as id,
n.nspname as schema,
c.relname as table,
c.oid :: int8 as table_id,
pol.polname as name,
case
when pol.polpermissive then 'PERMISSIVE'::text
else 'RESTRICTIVE'::text
end as action,
case
when pol.polroles = '{0}'::oid[] then array_to_json(string_to_array('public'::text, ''::text)::name[])
else array_to_json(array(
select pg_roles.rolname
from pg_roles
where pg_roles.oid = any(pol.polroles)
order by pg_roles.rolname
))
end as roles,
case pol.polcmd
when 'r'::"char" then 'SELECT'::text
when 'a'::"char" then 'INSERT'::text
when 'w'::"char" then 'UPDATE'::text
when 'd'::"char" then 'DELETE'::text
when '*'::"char" then 'ALL'::text
else null::text
end as command,
pg_get_expr(pol.polqual, pol.polrelid) as definition,
pg_get_expr(pol.polwithcheck, pol.polrelid) as check
from
pg_policy pol
join pg_class c on c.oid = pol.polrelid
left join pg_namespace n on n.oid = c.relnamespace
`