Accessing custom schema locally

export async function createClient() {
  const cookieStore = await cookies();

  return createServerClient(
    process.env.SUPABASE_URL!,
    process.env.SUPABASE_SERVICE_ROLE_KEY!,
    {
      db: {
        schema: "app",
      },

[api]
enabled = true
# Port to use for the API URL.
port = 54321
# Schemas to expose in your API. Tables, views and stored procedures in this schema will get API
# endpoints. `public` and `graphql_public` schemas are included by default.
schemas = ["app"]
# Extra schemas to add to the search_path of every request.
extra_search_path = ["app", "extensions"]

GRANT USAGE ON SCHEMA "app" TO "service_role";

-- Grant full access ONLY to service_role
GRANT ALL ON ALL TABLES IN SCHEMA "app" TO service_role;
GRANT ALL ON ALL SEQUENCES IN SCHEMA "app" TO service_role;
GRANT ALL ON ALL FUNCTIONS IN SCHEMA "app" TO service_role;