Supabase Change DB Schema

[tepid terrace]

Hi, i am unable to use DB shemas other then public when utilizing the nuxt/supabase module.

I tried to put the schema inline into await client.from('<schema>.<table>') but that didnt work.

I also tried to use the nuxt.config

supabase:{
  clientOptions: {
            db: {
                schema: '<schema>',
            }
  }
}

but its still using the public schema.

Does anyone know how to handle this?

[prime haven]

Hi @tepid terrace. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:

---

I apologize, but I don't have enough specific information in the provided knowledge sources to answer your question about changing the Supabase database schema in Nuxt with the Supabase module. The documents don't contain details about configuring Supabase schemas other than 'public' in Nuxt.

However, I can suggest a few general steps that might help:

1. Double-check that you're using the latest version of the @nuxtjs/supabase (https://supabase.nuxtjs.org) module, as newer versions might have additional configuration options.

2. Review the official Supabase documentation for any specific instructions on changing schemas, as this might be a Supabase-specific configuration rather than a Nuxt-specific one.

3. If you haven't already, you might want to ask this question in the Nuxt or Supabase community forums, as they might have more specific knowledge about this particular use case.

4. As a last resort, you could try to manually configure the Supabase client in your Nuxt app instead of relying on the module's auto-configuration, which might give you more control over the schema selection.

I apologize that I couldn't provide a more definitive answer based on the available information. If you need further assistance with Nuxt-specific issues, please feel free to ask, and I'll do my best to help based on the information available to me.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: