Redshift Observatory

System Table Tracker

System view pg_catalog.pg_views version 1.0.51304 / 2023-06-04

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