Alter auto-generated sequence

lorado

New Member
I use this to create auto-incremented id columns:\[code\] id BIGSERIAL -- psql id BIGINT GENERATED BY DEFAULT AS IDENTITY -- hsql\[/code\]Now in unit tests i'd like to reset those sequences between tests.Is this possible? I target PostgreSQL and HSQLDB
 
Top