after data migration, generate script for creating sequence and apply sequence on column in postgresql

sequence.sql

select 'create sequence ' ||v.sequencename || ' owned by ' || v.table_name::text || '.' ||v.column_name::text || ';' AS  createsequence, 
'alter table ' || v.table_name::text ||  ' alter column ' || v.column_name::text  
|| ' set default ' || v.column_default::text || ';'  as altercolumnscript
from 
(select 
v.table_name, v.column_name, v.column_default,
replace(replace(replace(REPLACE(v.column_default,'nextval',''),'::regclass',''),'(''',''),''')','')
as sequencename
from
information_schema.columns v 
 INNER JOIN
(
SELECT table_name FROM information_schema.tables WHERE table_schema='public'
)a 
on  a.table_name=v.table_name
where column_default is not null
and column_default like '%next%'
)as v