Reset PostgreSQL primary key to 1

by

The best way to reset a sequence to start back with number 1 is to execute the following:

ALTER SEQUENCE <tablename>_<id>_seq RESTART WITH 1

So, for example for the users table it would be:

ALTER SEQUENCE users_id_seq RESTART WITH 1

More Related Contents:

  1. How to reset postgres’ primary key sequence when it falls out of sync?
  2. Why can I create a table with PRIMARY KEY on a nullable column?
  3. How to add an auto-incrementing primary key to an existing table, in PostgreSQL?
  4. Changing primary key int type to serial
  5. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  6. PostgreSQL LIKE query performance variations
  7. Calculating and saving space in PostgreSQL
  8. PostgreSQL: ERROR: 42601: a column definition list is required for functions returning “record”
  9. I forgot the password I entered during postgres installation
  10. how to emulate “insert ignore” and “on duplicate key update” (sql merge) with postgresql?
  11. How do I efficiently select the previous non-null value?
  12. How do I do large non-blocking updates in PostgreSQL?
  13. How to configure PostgreSQL to accept all incoming connections
  14. Postgresql : Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections [duplicate]
  15. Dynamic SQL (EXECUTE) as condition for IF statement
  16. uWSGI, Flask, sqlalchemy, and postgres: SSL error: decryption failed or bad record mac
  17. serial in postgres is being increased even though I added on conflict do nothing
  18. Can’t connect to Postgresql on port 5432
  19. Spark Dataframes UPSERT to Postgres Table
  20. PostgreSQL Error: Relation already exists
  21. How to make a select with array contains value clause in psql
  22. Optimize Postgres query on timestamp range
  23. Use variable set by psql meta-command inside of DO block
  24. Sorting array elements
  25. How do I handle opening/closing Db connection in a Go app?
  26. Error: Column does not exist in postgresql for update [duplicate]
  27. How can I ensure that a materialized view is always up to date?
  28. PostgreSQL jsonb, `?` and JDBC
  29. Syntax error at end of input in PostgreSQL
  30. Error when pushing data to Heroku: time zone displacement out of range

Leave a Comment