Athena
Functions

List Postgres functions for the target client

Queries `pg_proc` for ordinary functions (`prokind = 'f'`). Requires management client context and `management.functions.read`.

GET
/management/functions

Query Parameters

schema?string

Filter by schema name

name_like?string

ILIKE pattern for function name (server wraps with %)

include_system?boolean

When false, excludes pg_catalog and information_schema

Defaultfalse
include_definition?boolean

When true, includes pg_get_functiondef in the response

Defaultfalse

Header Parameters

X-Athena-Client*string
apikey?string

Management API key (also accepted via x-api-key, Authorization Bearer, etc.)

Response Body

curl -X GET "https://athena-cluster.com/management/functions" \  -H "X-Athena-Client: string"
Empty
Empty
Empty
Empty
Empty

Drop a Postgres function by signature DELETE

Issues `DROP FUNCTION schema.function(arg_types...) RESTRICT`. Requires `management.functions.drop` and the same audit tables as upsert.

Create or replace a Postgres function from DDL PUT

Runs validated `CREATE OR REPLACE FUNCTION` DDL inside a transaction with audit tables. Requires `management.functions.write` Audit rows require `public.database_audit_log` and `public.function_ddl_audit_log` on the gateway logging Postgres database.