Skip to main content
Version: 2.x

tablefunc

The tablefunc module provides various functions that return tables (that is, multiple rows), such as normal_rand(), crosstab(), and connectby().

The Apache Cloudberry tablefunc module is equivalent to the PostgreSQL tablefunc module. There are no MPP-specific considerations for the module.

Install and register the module​

tablefunc is built and installed by a default Apache Cloudberry build. Register the extension in each database in which you want to use it:

CREATE EXTENSION tablefunc;

Module documentation​

See tablefunc in the PostgreSQL documentation for details about the individual functions in this module.