PostgreSQL move all extensions into separate schema

migration.sql

DO $$
DECLARE
    _name TEXT; 
    _ver TEXT;
BEGIN
    -- Loop over all extensions in `public` schema (except timescaledb) 
    -- and move it into `ext` schema
    FOR _name, _ver IN (
        SELECT 
            extname, 
            extversion 
        FROM 
            pg_extension ex
        INNER JOIN 
            pg_namespace ns ON ns.oid = ex.extnamespace 
        WHERE 
            nspname = 'public' AND extname not in ('timescaledb')
    ) LOOP
        RAISE NOTICE 'Counter: %: %', _name, _ver;

        EXECUTE 'UPDATE pg_extension SET extrelocatable = TRUE  WHERE extname = ''' || _name || '''';
        EXECUTE 'ALTER EXTENSION ' || _name || ' SET SCHEMA "ext"';
        EXECUTE 'ALTER EXTENSION ' || _name || ' UPDATE TO ''' || _ver || 'next''';
        EXECUTE 'ALTER EXTENSION ' || _name || ' UPDATE TO ''' || _ver || '''';
    END LOOP;
END $$;