Replace filenode with appropriate id. SELECT pg_catalog.pg_relation_filenode(c.oid) as "Object ID", relname as "Object Name", relkind='r', o.rolname as "Owner" FROM pg_catalog.pg_class c JOIN pg_catalog.pg_authid o ON o.oid=c.relowner JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace JOIN pg_catalog.pg_database d ON d.datname = pg_catalog.current_database() WHERE relfilenode=35489;
No comments:
Post a Comment