Javascript Reference v1.0

Call a Postgres function

Perform a function call.

You can call Postgres functions as Remote Procedure Calls, logic in your database that you can execute from anywhere. Functions are useful when the logic rarely changes—like for password resets and updates.

create or replace function hello_world() returns text as $$
  select 'Hello world';
$$ language sql;
Parameters
    params
    Optional
    undefined | object
    __namedParameters
    Optional
    object

const { data, error } = await supabase
  .rpc('hello_world')