Last updated 4 years ago
Was this helpful?
檢視表 pg_views 提供對資料庫中每個檢視表的詳細資訊。
pg_views
Column Type
Description
schemaname name (references .nspname)
schemaname
name
nspname
檢視表的綱要名稱
viewname name (references .relname)
viewname
relname
檢視表名稱
viewowner name (references .rolname)
viewowner
rolname
檢視圖的擁有者名稱
definition text
definition
text
檢視表的定義(重新建構的 SELECT 查詢)
pg_namespace
pg_class
pg_authid