Re: Reset Sequence number - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Reset Sequence number
Date
Msg-id ov3lk5$eke$1@blaine.gmane.org
Whole thread Raw
In response to [GENERAL] Reset Sequence number  (Brahmam Eswar <brahmam1234@gmail.com>)
List pgsql-general
Brahmam Eswar schrieb am 22.11.2017 um 10:36:
> 
> we are in process of migrating to postgres and need to reset the
> sequence number with highest value of table key. I want to make it
> procedural to do that as mentioned below, But it's throwing an error

> DO $$
>  DECLARE
>  SEQ BIGINT;
>  BEGIN 
>  
>  SEQ:=(SELECT MAX(ID) FROM TABLE_1);
>  ALTER SEQUENCE TABLE_1_SEQ  RESTART WITH SEQ;
>   
>  END$$; 
>  
> Error : syntax error at or near "SEQ"

No need for a PL/pgSQL block.

You can do that with a plain SQL statement using setval():
  select setval('table_1_seq', (select max(id) from table1));




pgsql-general by date:

Previous
From: Wèi Cōngruì
Date:
Subject: Re: [GENERAL] Reset Sequence number
Next
From: Alexander Pyhalov
Date:
Subject: duplicate primary key