Is there any way to reset all the sequences of tables, when truncate a table on cascade.
I already read this post How to reset sequence in postgres and fill id column with new data?
ALTER SEQUENCE seq RESTART WITH 1; UPDATE t SET idcolumn=nextval('seq');
It work only for one sequence, but my problem is to restart all the sequence of the truncated tables.
Consider when I use
TRUNCATE sch.mytable CASCADE; It affect 3 related tables, which mean three sequences, Is there any solution to restart this sequence in one shot.