Redshift Research Project

System Table Tracker

System view pg_catalog.pg_proc_info version 1.0.40182 / 2022-07-23

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