CALL

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

Examples

Invoke the 'sdb_functions' table function:

SQL

CALL sdb_functions();

Invoke the 'pragma_table_info' table function:

SQL

CALL pragma_table_info('pg_am');

 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_:

SQL

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

Syntax

Syntax