我使用以下查询从Postgresql目录表中获取Sequence对象的完整信息:
select s.sequence_name, s.start_value, s.minimum_value, s.maximum_value, s.increment, s.cycle_option
from information_schema.sequences s
where s.sequence_schema='schema1'
我无法获得的另一个属性值是 "Cache" 值。
我正在使用PostgreSQL 9.2
下面是带有缓存的序列DDL语法:
ALTER SEQUENCE [ IF EXISTS ] name [ INCREMENT [ BY ] increment ]
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ]
[ RESTART [ [ WITH ] restart ] ]
[ CACHE cache ] [ [ NO ] CYCLE ]
[ OWNED BY { table_name.column_name | NONE } ]
是否有任何Postgres函数可以获取此序列缓存值?
谢谢,
Ravi