maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_has_privilege(character varying, character varying)
Parameters
Name
Type
Mode
username
character varying
IN
permission
character varying
IN
table_name
character varying
OUT
Definition
WITH q AS (SELECT tablename::varchar tablename , has_table_privilege($1,tablename,permission) permission FROM pg_tables WHERE schemaname IN ('public')) SELECT tablename FROM q WHERE permission;