pg数据库操作-admin相关

--查看数据库中有哪些序列 --r =普通表， i =索引，S =序列，v =视图，m =物化视图， c =复合类型，t = TOAST表，f =外部表 select * from pg_class where relkind='S'

select * from pg_views where schemaname = 'public'

select * from information_schema.'columns' where table_name = 'newview'

select * from pg_trigger 

select * from pg_rules

select * from pg_class

select oid, nspname AS schemaname, nspacl ,pg_get_userbyid(nspowner) from pg_namespace where schemaname = 'public'