Acessar os USERS da table User do supabase através de uma FUNCTION

Supabase provides several options for creating database functions. You can use the Dashboard or create them directly using SQL.

We provide a SQL editor within the Dashboard, or you can connect to your database

and run the SQL queries yourself.

Go to the "SQL editor" section.

Click "New Query".

Enter the SQL to create or replace your Database function.

Click "Run" or cmd+enter (ctrl+enter).

Após entrar criar a function seguindo o exemplo

create or replace function get_planets()

returns setof planets

language sql

as $$

  select * from planets;

$$;

Para chamar no code:

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

const { data, error } = supabase.rpc('get_planets').eq('id', 1)

Pode-se passar argumentos ou não