Kotlin: Call a Postgres function

You can call stored procedures as a "Remote Procedure Call".

That's a fancy way of saying that you can put some logic into your database then call it from anywhere. It's especially useful when the logic rarely changes - like password resets and updates.

• When calling rpc with parameters, you have to provide a serializable value in the function parameter.

Parameters

• function

  (Required)

  The name of the function

• parameters

  (Optional)

  Parameters to pass to the function. T can be any serializable type.

• method

  (Optional)

  The HTTP method to use. Defaults to `RpcMethod.POST`

• request

  (Optional)

  Additional configuration & filtering for the request.

Examples

Call a stored procedure

supabase.postgrest.rpc("hello_world")

With Parameters

val rpcParams = City(name = "The Shire")
supabase.postgrest.rpc("echo_city", rpcParams)