美文网首页
列出所有自定义的function和view

列出所有自定义的function和view

作者: PythonDeveloper | 来源:发表于2018-01-16 11:26 被阅读7次

List Views

在pg_views中保存了View的信息,包括schemaname, viewname, viewowner and definition.

select * from pg_catalog.pg_views
where schemaname not in ('pg_catalog', 'information_schema')
order by schemaname, viewname;

Source

List Functions

SELECT  p.proname, p.prosrc
FROM    pg_catalog.pg_namespace n
JOIN    pg_catalog.pg_proc p
ON      p.pronamespace = n.oid
WHERE   n.nspname = 'public';

source

相关文章

网友评论

      本文标题:列出所有自定义的function和view

      本文链接:https://www.haomeiwen.com/subject/epqsoxtx.html