Is there a good way to test psql functions directl...
# sqls
stibbs
10/26/2021, 9:02 AMIs there a good way to test psql functions directly from the supabase ui?
h
HarryET
10/26/2021, 10:42 AMYou could just run them in the SQL Console?
s
stibbs
10/26/2021, 9:08 PMYou can call them from there?
stibbs
10/26/2021, 9:08 PMI want to check that I've got all return types etc correct as well. I've been calling it via JS to test but thought there might be a quicker method
stibbs
10/26/2021, 9:50 PMSo you just do
select "fn name here"(params);stibbs
10/26/2021, 9:50 PMDamn that would've saved time lol
h
HarryET
10/27/2021, 1:25 PMYeah!
HarryET
10/27/2021, 1:26 PMor if you dont want the response you can use
EXECUTEPERFORMHarryET
10/27/2021, 1:26 PMas was discused in #902127250487541771