Re: Reset Sequence number

["Raymond O'Donnell" <rod@xxxxxx>]

On 22/11/17 09:36, Brahmam Eswar wrote:
> 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);

select max(id) into seq from table_1;

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx