Redshift Research Project

System Table Tracker

System view pg_catalog.pg_proc_info version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog pg_proc_info proacl aclitem[]
pg_catalog pg_proc_info proallargtypes oid[]
pg_catalog pg_proc_info proargmodes char(1)[]
pg_catalog pg_proc_info proargnames text[]
pg_catalog pg_proc_info proargtypes oidvector
pg_catalog pg_proc_info probin bytea
pg_catalog pg_proc_info proisagg bool
pg_catalog pg_proc_info proisstrict bool
pg_catalog pg_proc_info prokind char(1)
pg_catalog pg_proc_info prolang oid
pg_catalog pg_proc_info proname name
pg_catalog pg_proc_info pronamespace oid
pg_catalog pg_proc_info pronargs int2
pg_catalog pg_proc_info prooid oid
pg_catalog pg_proc_info proowner int4
pg_catalog pg_proc_info proretset bool
pg_catalog pg_proc_info prorettype oid
pg_catalog pg_proc_info prosecdef bool
pg_catalog pg_proc_info prosrc text
pg_catalog pg_proc_info provolatile char(1)

View Text

SELECT pgp.oid AS prooid,
       pgp.proname,
       pgp.pronamespace,
       pgp.proowner,
       pgp.prolang,
       CAST(CASE
              WHEN pgp.prorettype = CAST(0 AS oid)
                THEN CAST('p' AS text)
              WHEN pgp.proisagg IS TRUE
                THEN CAST('a' AS text)
              ELSE CAST('f' AS text)
            END AS "char") AS prokind,
       pgp.proisagg,
       pgp.prosecdef,
       pgp.proisstrict,
       pgp.proretset,
       pgp.provolatile,
       pgp.pronargs,
       pgp.prorettype,
       pgp.proargtypes,
       CAST(pgpe0.value AS "char"[]) AS proargmodes,
       CAST(pgpe1.value AS oid[]) AS proallargtypes,
       CASE
         WHEN pgpe0.value IS NOT NULL
           THEN pgpe2.value
         ELSE pgp.proargnames
       END AS proargnames,
       pgp.prosrc,
       pgp.probin,
       pgp.proacl
FROM pg_proc AS pgp
     LEFT JOIN pg_proc_extended AS pgpe0 ON pgp.oid = pgpe0.procoid
                                        AND pgpe0.colnum = 0
     LEFT JOIN pg_proc_extended AS pgpe1 ON pgp.oid = pgpe1.procoid
                                        AND pgpe1.colnum = 1
     LEFT JOIN pg_proc_extended AS pgpe2 ON pgp.oid = pgpe2.procoid
                                        AND pgpe2.colnum = 2


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