shards.sql

 -- Create 100 schemas shard_001 - shard_100

DO $shards$
    BEGIN 
        FOR i IN 1..100 LOOP
            DECLARE shardID TEXT := CONCAT('shard_', to_char(i, 'FM000'));
            EXECUTE 'CREATE SCHEMA IF NOT EXISTS $1 AUTHORIZATION iflix;'
            INTO c USING shardID;
    END LOOP;
END $shards$;