postgresql 自增列 初始值设置
-- 获取自增列的名称 SELECT pg_get_serial_sequence('<your_table>', 'id')) AS sequence_name; --获取自增列的下一个值: SELECT nextval(pg_get_serial_sequence('<your_table>', 'id')) AS new_id; --设置自增列的下一个值: select setval(pg_get_serial_sequence('<your_table>', 'id'),1,false);
问题
https://stackoverflow.com/questions/62524324/get-all-sequences-with-current-values
select schemaname as schema, sequencename as sequence, last_value from pg_sequences
--max id :244 select * from report."TimezoneAbbreviation" ta order by "Id" desc limit 10 SELECT setval('report."TimezoneAbbreviation_Id_seq"', 244);