1. Home
  2. SQL

How to change a sequence of postgresql for id

Code examples

0
0

alter or change postgresql sequence counter 

SELECT setval('payments_id_seq', 21, true);  # next value will be 22

Similar pages

Similar pages with examples

how to change the sequence number in postgressql table column
postgresql update sequence value

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

alter postgres sequence
next value for sequence in postgresql
postgresql set sequence last value
sequence postgresql nextval change current value
changing id postgresql
postgresql update sequence number
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