Find schemas associated with a particular user
Select schemas in current db associated with user myuser, even if there are no tables in the schema, including public schema:
select 'public' as nspname
union all
select nspname
from pg_catalog.pg_namespace as nsp
join pg_catalog.pg_roles as rls
on nsp.nspowner = rls.oid
where rls.rolname = 'myuser';