Prisma ORM: Renaming a table/model when using database schemas

[merry yarrow]

Hi all! I am trying to rewrite a Prisma migration file in order to rename one of the models/tables. I think I have the syntax wrong possibly, because I am using database schemas, aka namespaces, and I think this syntax is wrong. Any suggestions?

Desired change: rename the model from Biller to User (I will also want to rename the schema itself but that's less important for now)

Existing schema file:

model Biller {
...

  @@schema("biller")
}

Custom migration script:

ALTER TABLE IF EXISTS "biller"."Biller" RENAME "biller"."Biller" to "biller"."User";

Error received upon attempting to apply migration:

Migration `20240327191753_change_biller_to_user_and_add_fields` failed to apply cleanly to the shadow database.
Error:
ERROR: syntax error at or near "."
   0: sql_schema_connector::validate_migrations
           with namespaces=Some(Namespaces("myapp", ["biller"]))

[dense wolf]

Hey @merry yarrow 👋

I would recommend you to have a look at this section of docs:

https://www.prisma.io/docs/orm/prisma-migrate/workflows/customizing-migrations#example-rename-a-field

This shows how you can rename a field, but the same could be applied for renaming a model

You can use the same technique to rename a model - edit the generated SQL to rename the table rather than drop and re-create it.

[merry yarrow]

I did read those docs but did not get it to work-I suspect it's because we're using the experimental multipleSchema flag. I will add an example when I'm in front of my computer