Update AWS RDS to give the rds_superuser role ownership of the topology schema

alter_postgis_topology_schema.sql

DO
$BODY$
DECLARE
    _sql   text;

BEGIN

  EXECUTE 'SET search_path = topology,public;';

  EXECUTE 'ALTER SCHEMA topology OWNER TO rds_superuser;';

  EXECUTE 'ALTER TABLE topology.topology OWNER TO rds_superuser;';

  EXECUTE 'ALTER TABLE topology.topology_id_seq OWNER TO rds_superuser;';

  EXECUTE 'ALTER SEQUENCE topology.topology_id_seq OWNER TO rds_superuser;';

  EXECUTE 'ALTER TABLE topology.layer OWNER TO rds_superuser;';

  SELECT INTO _sql
    string_agg('ALTER FUNCTION '
      || nsp.nspname || '.' 
      || p.proname || '(' 
      || pg_get_function_identity_arguments(p.oid)
      || ') OWNER TO rds_superuser;', E'\n'
    )
  FROM pg_catalog.pg_proc p
  JOIN pg_catalog.pg_namespace nsp ON p.pronamespace = nsp.oid
  WHERE nsp.nspname = 'topology';

  EXECUTE _sql;

END
$BODY$;