SELECT * FROM information_schema.sequences ;
SELECT * FROM information_schema.columns WHERE column_default LIKE 'nextval%';

SELECT * FROM information_schema.columns WHERE column_default LIKE 'nextval%';

nextval('files_f_id_seq'::regclass)

SELECT SUBSTRING(column_default,
strpos(column_default,'(')+2,
strpos(column_default,'::')-1 -(strpos(column_default,'(')+2)) as seq_name,* 
FROM information_schema.columns WHERE column_default LIKE 'nextval%';

select table_name,column_name,seq_name,nextval(seq_name::TEXT)
from 
(SELECT table_name,column_name,SUBSTRING(column_default,
strpos(column_default,'(')+2,
strpos(column_default,'::')-1 -(strpos(column_default,'(')+2)) as seq_name
FROM information_schema.columns WHERE column_default LIKE 'nextval%') t;