Athena
Functions

Create or replace a Postgres function from DDL

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.

PUT
/management/functions

Header Parameters

X-Athena-Client*string
apikey?string

Request Body

application/json

ddl*string

CREATE OR REPLACE FUNCTION ... DDL validated server-side

Response Body

curl -X PUT "https://athena-cluster.com/management/functions" \  -H "X-Athena-Client: string" \  -H "Content-Type: application/json" \  -d '{    "ddl": "string"  }'
Empty
Empty
Empty
Empty
Empty

List Postgres functions for the target client GET

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

Create an index POST

Requires `X-Athena-Client` and a client-bound API key with `management.indexes.write`.