「PostgreSQL」Viewビューの定義を調べる方法
環境
Windows 10 64bit
PostgreSQL 9.6.5
操作方法
1.全ビューを調べる
select viewname, definition from pg_views ;
select viewname, definition from pg_views ;
select viewname, definition from pg_views ;
2.指定ビューの定義を確認
select definition from pg_views where viewname = 'foreign_tables';
select definition from pg_views where viewname = 'foreign_tables';
select definition from pg_views where viewname = 'foreign_tables';