# Other Functions

> 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: Other Functions
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/index
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/index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/other-functions/index.adoc
description: Reference for other Redpanda SQL functions, including `COALESCE`, `NULLIF`, and PostgreSQL system information functions.
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.md -->

Besides [math](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/math-functions/), [aggregate](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/aggregate-functions/), [window](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/window-functions/), [string](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/string-functions/), [timestamp](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/timestamp-functions/), and [`json`](https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/json-functions/) functions, Redpanda SQL also supports these functions:

| Function | Description |
| --- | --- |
| COALESCE | Returns the first argument that is not NULL, while the remaining arguments from the first non-null argument are not evaluated. |
| current_database() | Returns the current database’s name. |
| current_schema() | Returns the schema’s name (first in the search path). |
| has_schema_privilege() | Checks whether the current user has specific privileges on a schema. |
| NULLIF | Replaces a given value with NULL if it matches a specific criterion. |
| pg_get_expr() | Retrieves the internal form of an individual expression (such as the default value for a column). |
| pg_total_relation_size() | Retrieves the size of a table. |
| pg_typeof() | Retrieves the data type of any given value. |
| pg_encoding_to_char() | Converts an encoding internal identifier to a human-readable name. |
| pg_get_indexdef() | Reconstructs the PostgreSQL command used to retrieve the definition of a specified index. |
| pg_get_userbyid() | Retrieves the name of a user (role) given its unique identifier (OID). |
| pg_relation_is_publishable() | Determines whether a specified relation (table) can be published in a publication. |
| pg_size_pretty() | Converts sizes in bytes into a human-readable format. |
| pg_table_size() | Retrieves the size of a specific table, including its associated storage components but excluding indexes. |
| pg_table_is_visible() | Checks whether a specified table (or other database object) is visible in the current schema search path. |
| pg_get_constraintdef() | Retrieves the definition of a specific constraint in a human-readable format. |
| pg_get_statisticsobjdef_columns() | Retrieves the definitions of columns associated with a specified statistics object. |
| obj_description() | Returns the comment associated with a specific database object. |
| col_description() | Retrieves the comment associated with a specified table column based on its name. |
| shobj_description() | Retrieves the comment associated with a shared database object. |
| pg_backend_pid() | Returns the process ID (PID) of the node handling the current session. |