WITH sequences AS (SELECT sequence_schema, sequence_name
FROM information_schema.sequences
WHERE sequence_schema NOT IN (SELECT schema_name
FROM information_schema.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)),
columns_with_sequences AS (SELECT A.table_schema, A.table_name , A.column_name, A.data_type, A.column_default
FROM information_schema.columns A
LEFT JOIN information_schema.domains d USING (domain_schema, domain_name)
INNER JOIN information_schema.tables T
ON A.table_schema = T.table_schema
AND A.table_name = T.table_name
INNER JOIN information_schema.schemata S
ON A.table_schema=S.schema_name
WHERE coalesce (a.column_default, d.domain_default) LIKE '%nextval%'
AND T.table_type='BASE TABLE'
AND (A.table_schema = 'public'
OR S.schema_owner<>'postgres'))
SELECT format('DROP SEQUENCE %1$I.%2$I;', sequence_schema, sequence_name) AS statements
FROM sequences AS s
WHERE NOT EXISTS (SELECT 1 FROM columns_with_sequences AS cs WHERE cs.column_default ILIKE '%' || replace(s.sequence_name,'_','\_') || '%')
ORDER BY sequence_schema, sequence_name;