CALL

The CALL statement invokes the given table function and returns the results.

Examples

Invoke the 'duckdb_functions' table function:

Query

CALL duckdb_functions();

Invoke the 'pragma_table_info' table function:

Query

CALL pragma_table_info('pg_am');

Result

 cid | name      | type    | notnull | dflt_value | pk-----+-----------+---------+---------+------------+----   0 | oid       | oid     | f       | NULL       | f   1 | amname    | name    | f       | NULL       | f   2 | amhandler | regproc | f       | NULL       | f   3 | amtype    | char    | f       | NULL       | f

Select only the functions where the name starts with ST_:

Query

SELECT function_name, parameters, parameter_types, return_typeFROM duckdb_functions()WHERE function_name LIKE 'ST_%';

Syntax