PostgreSQL show comments of all column in the specified table by query

column_comment.sql

-- https://www.postgresql.org/docs/current/infoschema-columns.html
SELECT
    cols.column_name,
    (
        SELECT
            pg_catalog.col_description(c.oid, cols.ordinal_position::int)
        FROM pg_catalog.pg_class c
        WHERE
            c.oid     = ((cols.table_schema||'.'||cols.table_name)::regclass::oid) AND
            c.relname = cols.table_name
    ) as column_comment
 
FROM information_schema.columns cols
WHERE
    cols.table_schema  = 'YOUR_SCHEMA' AND
    cols.table_name    = 'YOUR_TABLE';