List Functions and Procedures
pg_list_functionsList all user-defined functions, procedures, aggregates, and window functions in a PostgreSQL schema. Choose JSON or Markdown output format.
Instructions
List all user-defined functions, procedures, aggregates, and window functions in a schema.
Args:
schema: Schema name (default: public)
response_format: Output format
Returns: JSON: { functions: FunctionInfo[], count: number, schema: string } Markdown: formatted table with name, type, return type, arguments, language
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | PostgreSQL schema name (default: public) | public |
| response_format | No | Output format: 'markdown' for human-readable, 'json' for machine-readable | markdown |