Private stored procedures

[Nick-Mazuk]

Stored procedures seem to be created any time you create a function in Postgres. However, to use a trigger (e.g., create the public.users row when a new user signs up), you also need to create a function. And these functions seem to be callable from supabase-js.

Is there anyway to make some functions not callable as RPCs?

[steve-chavez]

Hey @Nick-Mazuk,

All functions in the public schema will be exposed through RPC. To keep them private, you can create them on another schema. Like:

create schema private; -- can be any name
create or replace function private.my_func(..)