https://stackoverflow.com › questions › 3819292

Is there a way to reset the primary key of a PostgreSQL table to start at 1 again on a populated table? Right now it's generating numbers from 1000000 and up. I want it all to reset and start to 1, keeping all my existing data intact.

https://stackoverflow.com › questions › 244243

ALTER SEQUENCE table_name_id_seq RESTART WITH 1; ALTER SEQUENCE table_name_id_seq RESTART; -- 8.4 or higher But ALTER SEQUENCE is of limited use because the sequence name and restart value cannot be expressions. It seems the best all-purpose solution is to call setval with false as the 3rd parameter, allowing us to specify the "next value to use":

https://www.slingacademy.com › article › postgresql-how-to-reset-the-auto-increment-value...

To reset the sequence to a specific value, you can use the following command: ALTER SEQUENCE sequence_name RESTART WITH <desired_value>; Make sure to replace sequence_name with your actual sequence name and <desired_value> with the value you wish to reset to.

https://dba.stackexchange.com › questions › 292617

We were able to reset a sequence with: SELECT setval('table_id_seq', (SELECT MAX(id) FROM table)); From version 10, using identity columns, there is no need to use the sequence name.

https://www.geeksforgeeks.org › how-to-reset-postgresql-primary-key-sequence-when-it...

We can reset our primary key sequence using following steps. Step 3: Resetting the Primary Key Sequence. Step 3.1: Identify the Sequence Name. First, find the name of the sequence associated with the primary key using the pg_get_serial_sequence() function. Syntax: SELECT pg_get_serial_sequence (‘table_name’, ‘column_name’); Example.

https://popsql.com › learn-sql › postgresql › how-to-alter-sequence-in-postgresql

Learn how to use the PostgreSQL 'Reset Sequence' command. If you have auto-incrementing serial ID columns, they typically start at 1. Sequences, managed in their designated tables, store essential details like start values and last values. Use 'Alter Sequence' to change the initial ID number.

https://www.slingacademy.com › article › postgresql-restart-rename-and-alter-sequences

p> This will reset the sequence to start at 1 again. Renaming a PostgreSQL Sequence. To rename an existing sequence in PostgreSQL, use the ALTER SEQUENCE command followed by RENAME TO. For instance: ALTER SEQUENCE my_sequence RENAME TO new_sequence_name; This renames my_sequence to new_sequence_name. Using pgAdmin to Alter a Sequence.

https://www.postgresql.org › docs › current › sql-altersequence.html

The optional clause RESTART [ WITH restart] changes the current value of the sequence. This is similar to calling the setval function with is_called = false : the specified value will be returned by the next call of nextval .

https://www.postgresql.org › docs › current › sql-altertable.htm

To add an automatically named primary key constraint to a table, noting that a table can only ever have one primary key: ALTER TABLE distributors ADD PRIMARY KEY (dist_id); To move a table to a different tablespace:

https://www.postgresqltutorial.com › postgresql-tutorial › postgresql-primary-key

Introduction to PostgreSQL primary key. A primary key is a column or a group of columns used to uniquely identify a row in a table. The column that participates in the primary key is known as the primary key column. A table can have zero or one primary key. It cannot have more than one primary key.