For postgres, can prisma use a schema different fr...
# orm-help
n
For postgres, can prisma use a schema different from public?
r
@Noel Martin Llevares Yes, you can pass in the schema in your Database URL like this:
Copy code
?schema=schemaName
n
Thanks.
👍 1
h
Is there any reason that you're using the Postgres schema rather than
public
? As far as I know, with PostgresSQL, schemas are a scoped within a single database, so I generally find it easier to separate between environments using a different database rather than different schema And when it’s not added explicitly to every DDL statement it defaults to 
public
 . Above question was asked by @Daniel Norman previously. @Noel Martin Llevares I also have the same question on your case.
👍 2