> For the complete documentation index, see [llms.txt](https://ploegert.gitbook.io/til/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ploegert.gitbook.io/til/programmy/linux/is-app-installed/sequence/restart-a-sequence.md).

# Restart A Sequence

In postgres, if you are truncating a table or doing some other sort of destructive action on a table in a development or testing environment, you may notice that the id sequence for the primary key just keeps plugging along from where it last left off. The sequence can be reset to any value like so:

```sql
> alter sequence my_table_id_seq restart with 1;
ALTER SEQUENCE
```

[source](http://www.postgresql.org/docs/current/static/sql-altersequence.html)