Alter auto-generated sequence

I use this to create auto-incremented id columns:

  id  BIGSERIAL                                -- psql
  id  BIGINT GENERATED BY DEFAULT AS IDENTITY  -- hsql

Now in unit tests i'd like to reset those sequences between tests.

Is this possible? I target PostgreSQL and HSQLDB

Solution

TRUNCATE table RESTART IDENTITY;