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.

Examples

Call a stored procedure

supabase.postgrest.rpc("hello_world")

With Parameters

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