1. Home
  2. SQL

Postgresql update sequence number

Code examples

2
0

postgresql update sequence next value 

ALTER SEQUENCE seq_name RESTART WITH 22;
1
0

update id sequence postgres 

-- Login to psql and run the following

-- What is the result?
SELECT MAX(id) FROM your_table;

-- Then run...
-- This should be higher than the last result.
SELECT nextval('your_table_id_seq');

-- If it's not higher... run this set the sequence last to your highest id. 
-- (wise to run a quick pg_dump first...)

BEGIN;
-- protect against concurrent inserts while you update the counter
LOCK TABLE your_table IN EXCLUSIVE MODE;
-- Update the sequence
SELECT setval('your_table_id_seq', COALESCE((SELECT MAX(id)+1 FROM your_table), 1), false);
COMMIT;

Similar pages

Similar pages with examples

postgres set sequence next value
how to update current value of sequence in postgres
update sequence number in postgres
postgresql select next value for sequence
postgresql change sequence current value
postgresql set sequence value
postgresql update sequence number
sequence postgresql nextval change current value
postgresql set sequence last value
next value for sequence in postgresql
postgresql update sequence value
changing id postgresql
alter postgres sequence

In other languages

This page is in other languages

Русский
..................................................................................................................
Ссылка
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
中文
..................................................................................................................
链接
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

Popular in the category

Popular pages with examples in the category

postgresql update bt column of other table
postgresql update from another database
psql update column from another table
how to update table with data from another table postgresql
postgres update fleld of tablename
change one column value in postgresql
select for update column value postgresql
postgres set value for column from another table
postgresql update column based on other table columns
postgres update table column from other table
update a table from another table in postgres
trigger on one column update postgres
how to update col in a table with another value from another table postgres
update from other table postgres
postgres update row with value from another row
postgres update columns with value from another column