| schema | name | column | data type |
|---|---|---|---|
| pg_catalog | svv_rls_relation | datname | varchar(128) |
| pg_catalog | svv_rls_relation | is_rls_datashare_on | char(1) |
| pg_catalog | svv_rls_relation | is_rls_on | char(1) |
| pg_catalog | svv_rls_relation | relkind | varchar(17) |
| pg_catalog | svv_rls_relation | relname | varchar(128) |
| pg_catalog | svv_rls_relation | relschema | varchar(128) |
| pg_catalog | svv_rls_relation | rls_conjunction_type | varchar(3) |
| pg_catalog | svv_rls_relation | rls_datashare_conjunction_type | varchar(3) |
SELECT rls_info_on_all_rels.datname,
rls_info_on_all_rels.relschema,
rls_info_on_all_rels.relname,
rls_info_on_all_rels.relkind,
rls_info_on_all_rels.is_rls_on,
rls_info_on_all_rels.is_rls_datashare_on,
rls_info_on_all_rels.rls_conjunction_type,
rls_info_on_all_rels.rls_datashare_conjunction_type
FROM (SELECT pgc.oid AS reloid,
CAST(current_database() AS varchar(128)) AS datname,
CAST(pns.nspname AS varchar(128)) AS relschema,
CAST(pgc.relname AS varchar(128)) AS relname,
CAST(CASE
WHEN pgc.relkind = CAST('r' AS "char")
THEN CAST('table' AS text)
WHEN pgc.relkind = CAST('v' AS "char")
THEN CASE
WHEN mvinfo.value IS NOT NULL
THEN CAST('materialized view' AS text)
WHEN pgc.relnatts = 0
THEN CAST('late binding view' AS text)
ELSE CAST('view' AS text)
END
ELSE CAST('unknown' AS text)
END AS varchar(17)) AS relkind,
CAST(CASE
WHEN rinfo.colnum = 20
AND rinfo.value = CAST('1' AS text)
THEN CAST('t' AS text)
ELSE CAST('f' AS text)
END AS char) AS is_rls_on,
CAST(CASE
WHEN rdsinfo.colnum = 25
THEN CASE
WHEN rdsinfo.value = CAST('0' AS text)
THEN CAST('f' AS text)
WHEN rdsinfo.value = CAST('1' AS text)
THEN CAST('t' AS text)
ELSE CAST('u' AS text)
END
ELSE CASE
WHEN CAST(CASE
WHEN rinfo.colnum = 20
AND rinfo.value = CAST('1' AS text)
THEN CAST('t' AS text)
ELSE CAST('f' AS text)
END AS char) = CAST('t' AS bpchar)
THEN CAST('t' AS text)
ELSE CAST('f' AS text)
END
END AS char) AS is_rls_datashare_on,
CAST(CASE
WHEN rminfo.colnum = 27
AND CAST(CAST(rminfo.value AS integer) & 1 AS boolean)
THEN CAST('or' AS text)
WHEN rminfo.colnum = 27
AND NOT CAST(CAST(rminfo.value AS integer) & 1 AS boolean)
THEN CAST('and' AS text)
ELSE CAST('and' AS text)
END AS varchar(3)) AS rls_conjunction_type,
CAST(CASE
WHEN rminfo.colnum = 27
AND CAST(CAST(rminfo.value AS integer) & 2 AS boolean)
THEN CAST('or' AS text)
WHEN rminfo.colnum = 27
AND NOT CAST(CAST(rminfo.value AS integer) & 2 AS boolean)
THEN CAST('and' AS text)
ELSE CAST('and' AS text)
END AS varchar(3)) AS rls_datashare_conjunction_type
FROM pg_namespace AS pns
INNER JOIN pg_class AS pgc ON pgc.relnamespace = pns.oid
LEFT JOIN (SELECT pgce.reloid,
pgce.colnum,
pgce.value
FROM pg_class_extended AS pgce
WHERE pgce.colnum = 20) AS rinfo ON rinfo.reloid = pgc.oid
LEFT JOIN (SELECT pgce.reloid,
pgce.value
FROM pg_class_extended AS pgce
WHERE pgce.colnum = 6) AS mvinfo ON mvinfo.reloid = pgc.oid
LEFT JOIN (SELECT pgce.reloid,
pgce.colnum,
pgce.value
FROM pg_class_extended AS pgce
WHERE pgce.colnum = 25) AS rdsinfo ON rdsinfo.reloid = pgc.oid
LEFT JOIN (SELECT pgce.reloid,
pgce.colnum,
pgce.value
FROM pg_class_extended AS pgce
WHERE pgce.colnum = 27) AS rminfo ON rminfo.reloid = pgc.oid
WHERE (CAST(CASE
WHEN rinfo.colnum = 20
AND rinfo.value = CAST('1' AS text)
THEN CAST('t' AS text)
ELSE CAST('f' AS text)
END AS char) = CAST('t' AS bpchar)
OR CAST(CASE
WHEN rdsinfo.colnum = 25
THEN CASE
WHEN rdsinfo.value = CAST('0' AS text)
THEN CAST('f' AS text)
WHEN rdsinfo.value = CAST('1' AS text)
THEN CAST('t' AS text)
ELSE CAST('u' AS text)
END
ELSE CASE
WHEN CAST(CASE
WHEN rinfo.colnum = 20
AND rinfo.value = CAST('1' AS text)
THEN CAST('t' AS text)
ELSE CAST('f' AS text)
END AS char) = CAST('t' AS bpchar)
THEN CAST('t' AS text)
ELSE CAST('f' AS text)
END
END AS char) = CAST('t' AS bpchar))
AND has_schema_privilege(CAST("current_user"() AS name),
CAST(pns.nspname AS text),
CAST('USAGE' AS text))) AS rls_info_on_all_rels
WHERE EXISTS (SELECT 1
FROM pg_identity
WHERE pg_identity.useid = current_user_id()
AND pg_identity.usesuper = TRUE)
OR has_system_privilege(CAST("current_user"() AS name),
CAST('CREATE RLS POLICY' AS text)) Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers