Skip to content

Instantly share code, notes, and snippets.

@slavamokerov
Last active June 2, 2023 14:27
Show Gist options
  • Save slavamokerov/7f98be752297856109d322d2916f9ee4 to your computer and use it in GitHub Desktop.
Save slavamokerov/7f98be752297856109d322d2916f9ee4 to your computer and use it in GitHub Desktop.
Creating sequence in an existing table. PostgreSQL
/*
objects_id_object_seq - sequence name
objects - table name
id_object - ID field name
seq - standard postfix
Doc for setval() and nextval(): https://www.postgresql.org/docs/current/functions-sequence.html
*/
CREATE SEQUENCE IF NOT EXISTS objects_id_object_seq; -- IF NOT EXISTS is works only in Postgres 9.5+
SELECT setval(
'objects_id_object_seq',
(SELECT max(id_object) FROM objects)
);
ALTER TABLE objects ALTER COLUMN id_object SET DEFAULT nextval('objects_id_object_seq');
@slavamokerov
Copy link
Author

slavamokerov commented Feb 5, 2022

Is there a reason for the increment in the maximum value

You're right, there's no reason. Fixed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment