SELECT 
       N.NSPNAME
      ,C.RELNAME
      ,OBJ_DESCRIPTION(C.OID) 
  FROM 
       PG_CATALOG.PG_CLASS C 
           INNER JOIN PG_CATALOG.PG_NAMESPACE N 
                   ON C.RELNAMESPACE = N.OID 
 WHERE 
       C.RELKIND = 'r'
   AND NSPNAME ILIKE 'public'  -- 스키마
   AND RELNAME ILIKE 'BZ_USER' -- 테이블
;