PG_TABLE_DEF doesn't work

I recently came across some websites that have guided me to a solution to perform a transpose function in RedShift. We currenltly have dataflows in MySQL that perform transpose functions with the use of stored procedures, however we would like to be able to convert those to RedShift. In any event, part of the solution relies on the use of PG_TABLE_DEF. When I try to use it, I get an error message saying "column [x] has unsupported type 'name'". If anyone knows how to avoid this/fix it let me know.

Thanks,