ebouchut · July 29, 2019 14:23
diff --git a/set_SQL_sequence.sql b/set_SQL_sequence.sql
 -- reset sequence to the max value of its ids
 SELECT setval('public.mytable_id_seq', (SELECT MAX(id) FROM mytable));
                                        
 -- get the last value of a sequence
 SELECT last_value FROM mytable_id_seq;
	-- reset sequence to the max value of its ids
	SELECT setval('public.mytable_id_seq', (SELECT MAX(id) FROM mytable));

	-- get the last value of a sequence
	SELECT last_value FROM mytable_id_seq;