Redshift Observatory

System Table Tracker

System view pg_catalog.pg_views version 1.0.41533 / 2022-09-18

schema name column data type
pg_catalog pg_views definition text
pg_catalog pg_views schemaname name
pg_catalog pg_views viewname name
pg_catalog pg_views viewowner name

View Text

SELECT n.nspname AS schemaname,
       c.relname AS viewname,
       pg_get_userbyid(c.relowner) AS viewowner,
       pg_get_viewdef(c.oid) AS definition
FROM pg_class AS c
     LEFT JOIN pg_namespace AS n ON n.oid = c.relnamespace
WHERE c.relkind = CAST('v' AS "char")


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