TypeScript problem with Supabase Type View

I have created this view

create view chat_profiles as
  select
    profiles.id,
    profiles.first_name,
    profiles.last_name
  from
    profiles

create view chat_profiles as
  select
    profiles.id,
    profiles.first_name,
    profiles.last_name
  from
    profiles

Exported the types via cli: npx supabase gen types typescript --local > database.types.ts

The view is not missing in the created file:

    Views: {
      chat_profiles: {
        Row: {
          first_name: string | null
          id: string
          last_name: string | null
        }
        Insert: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Update: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Relationships: []
      }
    }

    Views: {
      chat_profiles: {
        Row: {
          first_name: string | null
          id: string
          last_name: string | null
        }
        Insert: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Update: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Relationships: []
      }
    }

This is my Vue3 code:

const loadedChatProfiles = ref<Tables<"chat_profiles">[]>([]);
  const { data, error } = await client
    .from("chat_profiles")
    .select();

const loadedChatProfiles = ref<Tables<"chat_profiles">[]>([]);
  const { data, error } = await client
    .from("chat_profiles")
    .select();

This is my ts erorr:
[vue-tsc] Type '"chat_profiles"' does not satisfy the constraint '"app_permissions" | "app_roles" | "profiles" | "role_permissions" | { schema: keyof Database$1; }'.

Since it works with tables, it looks for me like my view is unknown, but the export helpers should also include view names:

export type Tables<
  PublicTableNameOrOptions extends
  | keyof PublicSchema["Tables"] | keyof PublicSchema["Views"]
  | { schema: keyof Database },

export type Tables<
  PublicTableNameOrOptions extends
  | keyof PublicSchema["Tables"] | keyof PublicSchema["Views"]
  | { schema: keyof Database },

tl;dr;
- fetching data from the view works
- but it looks like my view is unknown to typescript

Supabase•8mo ago

G0ldi98

TypeScript problem with Supabase Type View

I have created this view

create view chat_profiles as
  select
    profiles.id,
    profiles.first_name,
    profiles.last_name
  from
    profiles

create view chat_profiles as
  select
    profiles.id,
    profiles.first_name,
    profiles.last_name
  from
    profiles

Exported the types via cli: npx supabase gen types typescript --local > database.types.ts

The view is not missing in the created file:

    Views: {
      chat_profiles: {
        Row: {
          first_name: string | null
          id: string
          last_name: string | null
        }
        Insert: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Update: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Relationships: []
      }
    }

    Views: {
      chat_profiles: {
        Row: {
          first_name: string | null
          id: string
          last_name: string | null
        }
        Insert: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Update: {
          first_name?: string | null
          id?: string | null
          last_name?: string | null
        }
        Relationships: []
      }
    }

This is my Vue3 code:

const loadedChatProfiles = ref<Tables<"chat_profiles">[]>([]);
  const { data, error } = await client
    .from("chat_profiles")
    .select();

const loadedChatProfiles = ref<Tables<"chat_profiles">[]>([]);
  const { data, error } = await client
    .from("chat_profiles")
    .select();

export type Tables<
  PublicTableNameOrOptions extends
  | keyof PublicSchema["Tables"] | keyof PublicSchema["Views"]
  | { schema: keyof Database },

export type Tables<
  PublicTableNameOrOptions extends
  | keyof PublicSchema["Tables"] | keyof PublicSchema["Views"]
  | { schema: keyof Database },

tl;dr;
- fetching data from the view works
- but it looks like my view is unknown to typescript

TypeScript problem with Supabase Type View

TypeScript problem with Supabase Type View

Similar Threads

Similar Threads

Similar Threads