Reset auto increment counter in postgres

by

If you created the table product with an id column, then the sequence is not simply called product, but rather product_id_seq (that is, ${table}_${column}_seq).

This is the ALTER SEQUENCE command you need:

ALTER SEQUENCE product_id_seq RESTART WITH 1453

You can see the sequences in your database using the \ds command in psql. If you do \d product and look at the default constraint for your column, the nextval(...) call will specify the sequence name too.

More Related Contents:

  1. Auto increment table column
  2. Custom SERIAL / autoincrement per group of values
  3. Serial numbers per group of rows for compound key
  4. How to set auto increment primary key in PostgreSQL?
  5. Select first row in each GROUP BY group?
  6. How to use RETURNING with ON CONFLICT in PostgreSQL?
  7. Auto Increment after delete in MySQL
  8. Does PostgreSQL support “accent insensitive” collations?
  9. IN vs ANY operator in PostgreSQL
  10. Escaping keyword-like column names in Postgres
  11. How to include “zero” / “0” results in COUNT aggregate?
  12. SQL SELECT speed int vs varchar
  13. How do I force Postgres to use a particular index?
  14. Postgres Case Sensitivity
  15. Record returned from function has columns concatenated
  16. Query for element of array in JSON column
  17. INSERT rows into multiple tables in a single query, selecting from an involved table
  18. Casting NULL type when updating multiple rows
  19. Best way to delete millions of rows by ID
  20. How to find a table having a specific column in postgresql
  21. postgresql: INSERT INTO … (SELECT * …)
  22. How to read the contents of an .sql file into an R script to run a query?
  23. PostgreSQL JOIN with array type with array elements order, how to implement?
  24. Trim trailing spaces with PostgreSQL
  25. INSERT COMMAND :: ERROR: column “value” does not exist
  26. Check whether string is a date Postgresql
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. PostgreSQL: Full Text Search – How to search partial words?
  29. How to bulk insert only new rows in PostreSQL
  30. PostgreSQL – dynamic value as table name [duplicate]

Leave a Comment