https://supabase.com/ logo
Can you access tables on other schemes beyond publ...
# help
k
Can you access tables on other schemes beyond public using edge functions.
const { data, error }  = await supabase.from("schema.table").select();
n
Hello @Kevin Mann! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
k
If not what is the best way to move a table between schemas?
s
You can access tables on any schema with the right config. You just need to specify this when you are initiating the client library. The
createClient
methods takes a
schema
argument.
k
thank you will give that a try
I get back "permission denied for schema schema_name" Do I need a different key?
It the schema name is in the settings part which says: "The schema to expose in your API. "
g
Did you set grants on your schema?
k
I don't think we did I will give that ago now
Thank you that worked!!