not able to use local postgres database in prisma 2

[rajneesh3923]

I am trying to use my local postgres database in prisma 2 but it is throwing some error when is try to send the query. Below is the error I get in console

error: Error validating source db: The URL for datasource db must start with the protocol postgresql://.
--> schema.prisma:3
|
2 | provider = "postgresql"
3 | url = env("DATABASE_URL")
|

Validation Error Count: 1
at PrismaClientFetcher.request (D:\GraphQL\graphql-basics\node_modules@prisma\client\src\runtime\getPrismaClient.ts:652:34)
at processTicksAndRejections (internal/process/task_queues.js:97:5)

[ryands17]

Hey @rajneesh3923 👋
Did you create an .env file or add an environment variable named DATABASE_URL?
If not, then you would have to add the above to make it work.

e.g. An .env file in the prisma folder like this

DATABASE_URL=postgresql://username:password@url:5432/prisma2?schema=public

[rajneesh3923]

Now its working i just added ?schema=public and it starts working. Thanks