Find all tables that has 'auth_user' as Foreign Key

find_referred_tables.sql

select 
  (select 
    cls.relname 
    from 
    pg_class cls 
    where 
      cls.oid = cnstr.conrelid) as tbl,
  (select 
    array_agg(attname) 
    from 
    pg_attribute
    where 
      attrelid = cnstr.conrelid and ARRAY[attnum] <@ cnstr.conkey) as fk_col,
  (select 
    cls.relname 
    from 
    pg_class cls 
    where 
      cls.oid = cnstr.confrelid) as target
from pg_constraint cnstr
where 
  cnstr.confrelid = (select oid from pg_class where relname = 'auth_user');