How to not NOT NULL with Postgres: I am sure this ...
# orm-help
b
How to not NOT NULL with Postgres: I am sure this question has been asked before but I do not see an answer here in Slack nor with this doc https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference
Copy code
"ordering" INTEGER NOT NULL,
    "title" VARCHAR(255) NOT NULL,
Copy code
ordering  Int       
  title     String    @db.VarChar(255)
what if I wish to allow for nulls
it seems prism defaults to NOT NULL for postgres columns
n
Hey 👋 It seems you are looking for`?` modifier - Reference In your schema, you can append ? to the data type to make it optional.
Copy code
ordering  Int?       
title     String?    @db.VarChar(255)
b
@Nurul I think that is it! Thank you, that one is not intuitive 🙂