PG_TABLE_DEF doesn't work

baroncurtin
baroncurtin
in Dataflows

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, 

Comments

  • Matthew_H
    Matthew_H

    Any updates on this? I like how Domo is getting more "pretty" with redesigning all the icons and all, but such basic functionalities are still missing ?

  • pairwin
    pairwin ⚪️

    +1 to this question. Anyone? Bueller?

Categories