How to reset sequence in postgres and fill id column with new data?

by

If you don’t want to retain the ordering of ids, then you can

ALTER SEQUENCE seq RESTART WITH 1;
UPDATE t SET idcolumn=nextval('seq');

I doubt there’s an easy way to do that in the order of your choice without recreating the whole table.

More Related Contents:

  1. Why does PostgreSQL perform sequential scan on indexed column?
  2. In-order sequence generation
  3. Insert, on duplicate update in PostgreSQL?
  4. How does the search_path influence identifier resolution and the “current schema”
  5. How do you find the row count for all your tables in Postgres
  6. Run batch file with psql command without password
  7. invalid byte sequence for encoding “UTF8”
  8. Postgresql: Conditionally unique constraint
  9. How do you use variables in a simple PostgreSQL script?
  10. How to switch databases in psql?
  11. Postgresql: Scripting psql execution with password
  12. Postgresql Truncation speed
  13. Buffers (Circle) in PostGIS
  14. docker postgres pgadmin local connection
  15. How to customize the configuration file of the official PostgreSQL Docker image?
  16. Does a Postgres UNIQUE constraint imply an index?
  17. SELECT raises exception in PL/pgSQL function
  18. Dynamically generate columns for crosstab in PostgreSQL
  19. I forgot the password I entered during PostgreSQL installation
  20. Function to loop through and select data from multiple tables
  21. SQL query column does not exist error
  22. SQL Sub queries in check constraint
  23. Postgresql enforce unique two-way combination of columns
  24. PostgreSQL how to concat interval value ‘2 days’
  25. Displaying image in Ireports using PostgreSql
  26. Orbeon Forms Postgres DB connection
  27. Postgres default sort by id – worldship
  28. Best way to install hstore on multiple schemas in a Postgres database?
  29. Loop through columns of RECORD
  30. How to drop PostgreSQL database through command line [closed]

Leave a Comment