Postgresql get all columns info

get_columns_info.sql

SELECT
    cols.table_catalog as database,
    cols.table_schema as schema,
    cols.table_name,
    _table.description,
    cols.column_name,
    cols.is_nullable,
    cols.data_type,
    cols.character_maximum_length,
    (
        SELECT
            pg_catalog.col_description(c.oid, cols.ordinal_position::int)
        FROM pg_catalog.pg_class c
        WHERE
            c.oid     = (SELECT cols.table_name::regclass::oid) AND
            c.relname = cols.table_name
    ) as column_comment
 
FROM information_schema.columns cols

LEFT JOIN (
			SELECT pgc.*,t.*,
				   pg_catalog.obj_description(pgc.oid, 'pg_class') as description
			FROM information_schema.tables t
			INNER JOIN pg_catalog.pg_class pgc
		   	 	ON t.table_name = pgc.relname
		   ) _table
	ON _table.table_catalog = cols.table_catalog
   AND _table.table_schema  = cols.table_schema
   AND _table.table_name    = cols.table_name
   AND _table.description IS NOT NULL

WHERE
    cols.table_catalog = 'gtrp-teste' AND
    cols.table_schema  = 'inusitta'  

ORDER BY cols.table_catalog,
		 cols.table_schema,
		 cols.table_name,
		 cols.ordinal_position