--pg_attribute字段定义全在这里
select * from pg_attribute
where attrelid = any(
--表名称
select oid from pg_class where relname='users' and relnamespace=any(
--架构名称
select oid from pg_namespace where nspname='public'
)
)
查询用户函数
/*16384是用户编号,通过以下sql查询,必须以postgres身份运行*/
select oid from pg_authid where rolname='用户名';
/*查询所有者为16384的所有函数*/
select oid,* from pg_proc where proowner='16384';
/*查询所有者为16384并且名称为xxxxx的函数*/
select oid,* from pg_proc where proowner='16384' and proname= lower('xxxxx')