PostgreSQLでテーブルの列を取得するクエリ

SELECT
    att.attnum AS NUM,
    att.attname AS COL_NAME,
    typ.typname AS COL_TYPE,
    com.description AS COL_COMMENT

FROM
    pg_class cls
    LEFT JOIN pg_attribute att ON cls.oid=att.attrelid
    LEFT JOIN pg_type typ ON att.atttypid=typ.oid
    LEFT JOIN pg_description com ON att.attrelid = com.objoid
                                    AND att.attnum = com.objsubid

WHERE

    att.attnum > 0
AND cls.relname = 't_hogehoge'

ORDER BY
    att.attnum