Postgresql: tablespace tables node id tracking

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