DT
Drizzle Teampax

Querying a materialized view: relation does not exist

I define a materialized view as such: 
export const usersMv = pgMaterializedView("users_mv").as(
  (qb) => {
    return qb
      .select({
        name: users.name,
      })
      .from(users)
  }
)
export const usersMv = pgMaterializedView("users_mv").as(
  (qb) => {
    return qb
      .select({
        name: users.name,
      })
      .from(users)
  }
)
Then I query this materialized view: 
  const results = await db
    .select()
    .from(usersMv)
  const results = await db
    .select()
    .from(usersMv)
But I get the error: 
NeonDbError: relation "users_mv" does not exist
NeonDbError: relation "users_mv" does not exist
I'm using Neon. Does Drizzle know how to create the materialized view for me?
J
joshpachner•12d ago
hey @pax , I dont have the answer for ya. but you could create the view normally in your database, and then just add the .existing() at the end of your drizzle view declaration. (thats what i do for my views, and so that i have more control over it in writing the raw sql)
Want results from more Discord servers?
Add your server
More Posts
default to empty object for sqlite text field with JSON modeHow can I default a `mode: 'json'` text type to an empty object in sqlite? The following in a `sqliConverting a field from X type to Serial causes errorsI'm attempting to convert a field from type `text` to type `serial`. Here's the error I'm seeing: `Return type is only "with" types, ignores "columns" typesNot sure if I'm using it wrong but the return type of a relational query is just the columns from thonUpdateupdatedAt: timestamp('updated_at', { mode: 'date', precision: 3 }) .defaultNow() .$onUpdate(