Loop over schemas in a Postgresql database and execute arbitrary DDL example

update_schemas.sql

DO
$$
DECLARE
    schemaname name;
BEGIN
   FOR schemaname IN SELECT nspname FROM pg_namespace WHERE nspname  LIKE 'schema_%' AND nspname <> 'information_schema' LOOP
        RAISE NOTICE 'Running Alter on Schema : %', schemaname;
        EXECUTE format('ALTER TABLE %I.common_commonconfigure ADD COLUMN google_secret_key varchar(150);', schemaname);
   END LOOP;
END;
$$ LANGUAGE plpgsql;