Cc @copple I hope you don't mind me tagging

Hey @User , we hope for this Discord to be community-led. But the team will help with any questions on our GitHub (https://github.com/supabase/supabase/discussions). For you particular question - you can check out

pg-tap

which might help (although I wouldn't personally use plv8 for production workloads when you have great JS frameworks like Next/Nuxt)

Gotcha, thanks

This is in 'database'

Table editor

Having a similar issue, can create db from my platform, then the db user is unable to access that db, so assuming rights issue, however that db doesnt display unless you query pgdata

I had deleted

storage

and

users

table from database

Can I revert this 😦

ouch

If anyone knows a solution please @ me 🙂

where's the REST API documentation for PostgREST?

https://postgrest.org/en/stable/api.html ?

awesome thank you

I'd suggest remaking your project tbh

easier than trying to rebuild the tables imo

Alright thanks... Tbh they shouldn't be deletable at first place.

also true

how do I create RPC in supabase

im saving a simple query but it's not working

when i do

.rpc("name_of_query")

is there any other way to declare RPC

What's the query?

rpc(<name: string, params?: object>)

is the way to run them

Im following this oficial guide to execute rpchttps://supabase.io/docs/reference/javascript/rpc

If you run

select * from my_function()

via the SQL editor, does it return anything, or any errors?

btw it's just creating table nothing query type.. but query was easier to say

yep i m running it using website UI and it's working

wait what? my_function() what's that

That's just a psuedo name for a function - it's whatever your function is called

If your function is called

get_food

, you'd run

select * from get_food()

this