# col_description

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: col_description
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/other-functions/col-description
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/other-functions/col-description.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/other-functions/col-description.adoc
description: col_description() is a comment information function that retrieves the comment associated with a specified table column.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/other-functions/col-description.md -->

The [col\_description()](https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-COMMENT) is a comment information function that retrieves the comment associated with a specified table column.

## [](#syntax)Syntax

The syntax for this function is:

col\_description (table\_oid, column\_number) → text

## [](#parameters)Parameters

-   [table\_oid](https://www.postgresql.org/docs/current/datatype-oid.html): specifies the object identifier (OID) of the table containing the column from which to retrieve the comment

-   [column\_number](https://www.postgresql.org/docs/current/datatype-numeric.html#DATATYPE-INT): indicates the ordinal position of the column within the table (starting from 1 for the first column)


> 📝 **NOTE**
>
> It is important to note that the column number must be provided as an object identifier (OID), which can be achieved by casting the table name to `regclass`

## [](#restrictions)Restrictions

-   This implementation returns `NULL` when either parameter (`table_oid` or `column_number`) is `NULL`.