Flutter: 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.

Examples

Call a stored procedure

final data = await supabase
  .rpc('hello_world');

With Parameters

final data = await supabase
  .rpc('echo_city', params: \{ 'name': 'The Shire' \});