Checking list of security definer functions in GPDB
Post date: May 11, 2016 11:55:56 AM
testdb=# \d pg_proc
Table "pg_catalog.pg_proc"
Column | Type | Modifiers
----------------+-----------+-----------
proname | name | not null
pronamespace | oid | not null
proowner | oid | not null
prolang | oid | not null
proisagg | boolean | not null
prosecdef | boolean | not null
proisstrict | boolean | not null
proretset | boolean | not null
provolatile | "char" | not null
pronargs | smallint | not null
prorettype | oid | not null
proiswin | boolean | not null
proargtypes | oidvector | not null
proallargtypes | oid[] |
proargmodes | "char"[] |
proargnames | text[] |
prosrc | text |
probin | bytea |
proacl | aclitem[] |
prodataaccess | "char" | not null
Indexes:
"pg_proc_oid_index" UNIQUE, btree (oid)
"pg_proc_proname_args_nsp_index" UNIQUE, btree (proname, proargtypes, pronamespace)
testdb=#
psql> select proname from pg_proc where prosecdef is TRUE;