script to check tables under which schema in aws redshift database?

script to check tables under   which schema in aws redshift database 

SELECT

TRIM(nspname) AS schema_name,

TRIM(relname) AS table_name,

relcreationtime AS creation_time

FROM pg_class_info

LEFT JOIN pg_namespace ON pg_class_info.relnamespace = pg_namespace.oid

WHERE reltype != 0

AND TRIM(nspname) = 'app_username';