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