1.查询某个用户的拥有的对象 这里是postgres,可以换成对应用户 select nsp.nspname as SchemaName ,cls.relname as ObjectName ,rol.rolname as ObjectOwner ,case cls.relkind when 'r' then 'TABLE' when 'm'