pg_class 如何安装relfrozenxid 升序排列

我来答

匿名用户

postgresql

relfrozenxid 是xid类型

想安装relfrozenxid大小从小到大排序

order by relfrozenxid 报错

order by relfrozenxid::int 也报错

我来答

添加附件

问题补充

3条回答

默认

最新

刘贵宾

语句发出来看一下

有用 0

手机用户9375

2022-09-05

HINT: Use an explicit ordering operator or modify the query. postgres@[local]:5432=#2630 select relname,relfrozenxid from pg_class order by relfrozenxid desc; ERROR: could not identify an ordering operator for type xid LINE 1: ...elect relname,relfrozenxid from pg_class order by relfrozenx... ^ HINT: Use an explicit ordering operator or modify the query. postgres@[local]:5432=#2630 postgres@[local]:5432=#2630 select relname,relfrozenxid from pg_class order by relfrozenxid::int desc; ERROR: cannot cast type xid to integer LINE 1: ...e,relfrozenxid from pg_class order by relfrozenxid::int desc...

刘贵宾

select relname,relfrozenxid from pg_class order by relfrozenxid::text::bigint desc;

有用 1

刘贵宾

答主

2022-09-05

对你有帮助的话，希望采纳哦

刘贵宾

SELECT n.nspname as "Schema", c.relname as "Name", c.relfrozenxid,age(c.relfrozenxid)
FROM pg_catalog.pg_class c
LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind IN ('r','')
AND n.nspname <> 'information_schema' AND n.nspname !~ '^pg_toast'
AND pg_catalog.pg_table_is_visible(c.oid)
ORDER BY c.relfrozenxid::text::bigint DESC;

有用 2

回答交流

提交

问题信息

请登录之后查看

邀请回答

暂无人订阅该标签，敬请期待~~

墨值悬赏