script to check who is the owner of the schema in Redshift

script to check who is the owner of the schema in Redshift

select n.nspname, u.usename as owner from pg_catalog.pg_namespace n, pg_user  u where n.nspname='schema4' and n.nspowner=u.usesysid;