(That SQL statement was for MySQL/MariaDB and might work on PG)
Try UPDATE SQLITE_SEQUENCE SET SEQ=0 WHERE NAME='table_name'; for SQLite, gathered from: sql - SQLite Reset Primary Key Field - Stack Overflow
1 Like