如何获取Postgres序列的最大值和最小值?
我使用以下语句创建了该序列:
create sequence seqtest increment 1 minvalue 0 maxvalue 20;
我尝试了这个查询
select max_value from seqtest
,但是出现了错误。ERROR: column "max_value" does not exist
LINE 1: select max_value from seqtest;
HINT: Perhaps you meant to reference the column "seqtest.last_value".
select * from seqtest
的输出结果
test=# select * from seqtest;
-[ RECORD 1 ]-
last_value | 0
log_cnt | 0
is_called | f