testdb=# select oid,pg_relation_filenode(oid),relname from pg_class where relname like 'pg_type%';
oid | pg_relation_filenode | relname
------+----------------------+------------------------------
2703 | 10008 | pg_type_oid_index
2704 | 10009 | pg_type_typname_nsp_index
1247 | 12550 | pg_type
6220 | 12751 | pg_type_encoding
6207 | 10147 | pg_type_encoding_typid_index
(5 rows)
greenplum6查找表的relfilenode
最新推荐文章于 2024-03-19 09:25:43 发布